I am using access 2000 for an intranet site, and would like to know how to
get the recordid of a newly created record.
here is the code.
INSERT INTO TableName
(FieldName)
VALUES('#Form.FieldValue#')
I want to be able to display the newly created record, but need the key
value
The usual solution is to wrap two queries into a cftransaction
Question of my own: I've never really found out what the difference is
in the various isolation levels. Can someone explain them, or point me
in the right direction?
Options:
TIA.
--
Billy Cravens
[EMAIL PROTECTED]
E
- Original Message -
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 12, 2000 12:20 PM
Subject: MS Access getting the FieldID from a newly inserted record
I am using access 2000 for an intranet site, and would like t
3 matches
Mail list logo