Personally, if you are trying to do what I think you are trying to do,
I accomplish it with a 'trick' (aka kludge).
When users open my Access 2000 app I add a record to an Access table
called 'sessions' and keep track of the session_id which is created.
The postgres records I need id's from have the session id stored in them
at creation with the rest of the data, as well as a timestamp.
so I do the following to get the key value of the record I just
MyNow = Now()
rsData!creation_date = MyNow
rsData!session_id = MySession
then I run a query which asks for the key value of the record with
session_id = MySession and creation_date = MyNow.
Works every time
Lots of luck
>>> Mike Fahey <mfahey(at)enter(dot)net> 11/12/2004 9:36:23 AM >>>
So I guess the question still remains, how do you get the last inserted
id from a sequence?
I'm using access 2003 & postgres odbc 8.0.02
select @@IDENTITY seems to be MS Specific and not work with postgres.
calling currval has to be a pass-through query which makes it high
complicated if at all
How does everyone else do this ?
How does any database maintain referential integrity if this doesn't
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
pgsql-odbc by date
|Next:||From: Jaime Casanova||Date: 2004-11-12 21:10:28|
|Subject: Re: ODBC Driver stability|
|Previous:||From: Mike Fahey||Date: 2004-11-12 17:36:23|
|Subject: Getting the last inserted id|