oops. sorry.. ;-) its the Access equivelant of @@identity
_____
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 28 November 2003 13:41
To: CF-Talk
Subject: RE: Getting last inserted idenity value
Which scope i.e queryname.MaxID...? Is it CF Function?
_____
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: 28 November 2003 13:31
To: CF-Talk
Subject: RE: Getting last inserted idenity value
Try MaxID.
_____
From: Shahzad.Butt [mailto:[EMAIL PROTECTED]
Sent: 28 November 2003 13:25
To: CF-Talk
Subject: Getting last inserted idenity value
Hi
I am using CFMX and Access2000. In my action page I've got two insertion
queries one inserts in table1 and other one inserts in table2. Both of
these tables has got primary key as autoincrement number. Second query
needs to add the primary key generated from first query as a foreign
key. How would I get the PK of the record just inserted. I know in
SQLServer we could use @@IDENTITY but unfortunately I am using access at
the moment
Thanks
Shahzad.Butt
Ph: +44 (0) 1992 701 722
Fax: +44 (0) 1992 701 604
_____
_____
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Getting last inserted idenity value Shahzad.Butt
- RE: Getting last inserted idenity value Kwang Suh
- RE: Getting last inserted idenity value Robertson-Ravo, Neil (RX)
- RE: Getting last inserted idenity value John Beynon
- RE: Getting last inserted idenity value Shahzad.Butt
- RE: Getting last inserted idenity value John Beynon
- RE: Getting last inserted idenity value Robertson-Ravo, Neil (RX)
- RE: Getting last inserted idenity value John Beynon