U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » PostgreSQL GetInsertedId()

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

Re: PostgreSQL GetInsertedId() [message #16619 is a reply to message #16618]

Wed, 02 July 2008 16:46

captainc
Messages: 278
Registered: December 2006
Location: New Jersey, USA

Experienced Member

Idea 2: Have a mapping of sequences to table names from the .sch file.

Something like:
String seq = m_session.GetPKSequence(TABLENAME)

and we could use it like this:

...insert statement...
sql.GetInsertedId(seq)

and/or

sql.GetNextId(seq)
...insert statement...

Idea 3: Create a separate insert function called InsertSelect which will return 0 (or -1) for a failed insert and otherwise return 1..N which would be the last inserted id using the method described in the above post. So this would mean we would have 1 insert with no overhead and 1 with the overhead of getting the inserted id and returning it.

Report message to a moderator

[Message index]

		PostgreSQL GetInsertedId() By: captainc on Wed, 02 July 2008 16:34
		Re: PostgreSQL GetInsertedId() By: captainc on Wed, 02 July 2008 16:46
		Re: PostgreSQL GetInsertedId() By: mirek on Wed, 02 July 2008 23:17
		Re: PostgreSQL GetInsertedId() By: captainc on Thu, 03 July 2008 13:48
		Re: PostgreSQL GetInsertedId() By: mirek on Fri, 04 July 2008 13:49
		Re: PostgreSQL GetInsertedId() By: captainc on Mon, 07 July 2008 19:45
		Re: PostgreSQL GetInsertedId() By: unodgs on Mon, 07 July 2008 22:15
		Re: PostgreSQL GetInsertedId() By: mirek on Mon, 07 July 2008 22:17
		Re: PostgreSQL GetInsertedId() By: unodgs on Mon, 07 July 2008 22:46
		Re: PostgreSQL GetInsertedId() By: zsolt on Mon, 07 July 2008 22:49
		Re: PostgreSQL GetInsertedId() By: mirek on Tue, 08 July 2008 07:22
		Re: PostgreSQL GetInsertedId() By: zsolt on Tue, 08 July 2008 08:55
		Re: PostgreSQL GetInsertedId() By: zsolt on Mon, 07 July 2008 22:48
		Re: PostgreSQL GetInsertedId() By: mirek on Tue, 08 July 2008 15:57
		Re: PostgreSQL GetInsertedId() By: zsolt on Tue, 08 July 2008 16:56
		Re: PostgreSQL GetInsertedId() By: captainc on Tue, 08 July 2008 21:58

Previous Topic:	Quick explanation of function calls for postgresql
Next Topic:	db access to MS ACCESS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun May 12 17:18:41 CEST 2024

Total time taken to generate the page: 0.02214 seconds