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 #16696 is a reply to message #16692]

Mon, 07 July 2008 22:46

unodgs
Messages: 1366
Registered: November 2005
Location: Poland

Ultimate Contributor

Quote:

Does not help, MySQL does not have sequences.
Frankly, this is troublesome problem with many dead ends...

I said add not replace Smile

:
int GetInsertedId() - for database with autoincrement fields
int GetInsertedId(const char* s) - for database with sequences

or just current GetInsertedId could be replaced with

int GetInsertedId(const char* s = NULL)

if sequence name is null it returns last valid inserted id (of course for databases which supports this way).

This do not solve assist problem - you have to know what getinsertedid to use for your database.

[Updated on: Mon, 07 July 2008 22:48]

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: Mon May 13 03:56:32 CEST 2024

Total time taken to generate the page: 0.02486 seconds