U++ framework: U++ SQL » Postgres and CurrVal

Home » U++ Library support » U++ SQL » Postgres and CurrVal

Tue, 08 September 2009 16:18

Zbych
Messages: 332
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?

		Postgres and CurrVal By: Zbych on Tue, 08 September 2009 16:18
		Re: Postgres and CurrVal By: mirek on Thu, 10 September 2009 12:01
		Re: Postgres and CurrVal By: Zbych on Thu, 10 September 2009 12:52
		Re: Postgres and CurrVal By: mirek on Thu, 10 September 2009 14:12
		Re: Postgres and CurrVal By: Zbych on Fri, 11 September 2009 13:36
		Re: Postgres and CurrVal By: mirek on Thu, 17 September 2009 17:26
		Re: Postgres and CurrVal By: Zbych on Fri, 18 September 2009 10:25
		Re: Postgres and CurrVal By: mirek on Thu, 24 September 2009 10:42

Previous Topic:	Acquiring large record
Next Topic:	Can I use Upp::Oracle8 connect to Oracle10?

Goto Forum:

] [

]

Current Time: Tue Apr 28 06:37:03 GMT+2 2026

Total time taken to generate the page: 0.00529 seconds