U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Return to the default flat view

Create a new topic

Submit Reply

Re: Postgres and CurrVal [message #23044 is a reply to message #23043]

Thu, 10 September 2009 12:52

Zbych is currently offline

Zbych
Messages: 327
Registered: July 2009

Senior Member

luzr wrote on Thu, 10 September 2009 12:01

which IMO is correct.

I would need a more complete testcase to investigate the issue...

Sorry, my mistake. I had to replace upp's SqlInsert with "query in string" + ExecuteX to insert many rows at once, and I've used ~CurrVal(). That's why I had this funny version of currval.

BTW. Is there a way to force SqlInsert, to create single insert with many rows:

insert into testpartner (testpartner_name, testpartner_address)
values
('qweqwe','qweqweqwe'),
('qweqwe','qweqweqwe'),
('qweqwe','qweqweqwe'),
('qweqwe','qweqweqwe')

Report message to a moderator

Send a private message to this user

[Message index]

		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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Sun Aug 24 12:27:41 CEST 2025

Total time taken to generate the page: 0.00670 seconds