Home » U++ Library support » U++ SQL » Postgres and CurrVal
Postgres and CurrVal [message #23025] |
Tue, 08 September 2009 16:18 |
Zbych
Messages: 326 Registered: July 2009
|
Senior Member |
|
|
Hi,
CurrVal doesn't seem to work correctly with Postgres right now.
When I use it like this:
sql & Insert(TABLE1)(COLUMN1, "test")(COLUMN2, CurrVal(TABLE2_COLUMN1_SEQ));
Sql string looks like this:
insert into TABLE1 (COLUMN1, COLUMN2) values ('test',currval('TABLE2_COLUMN1_SEQ')TABLE2_COLUMN1_SEQ.CURRVAL))
It looks like SqlCase is not "compiled". Any ideas how to fix it?
|
|
|
Goto Forum:
Current Time: Sat May 04 10:04:37 CEST 2024
Total time taken to generate the page: 0.03052 seconds
|