[thelist] rowset doesn't support fetching backwards??
Fortune Elkins
fortune_elkins at summithq.com
Fri Apr 20 15:14:20 CDT 2001
hiya!
i'm trying to fetch the autonumber ID of an item i just inserted into Access
2000, which apparently doesn't support @@IDENTITY. i'm using my favorite
application, UltraDev 4.
here's my little code:
MM_editCmd.Execute
rsInsertRec.MoveLast
intEntryNumber=rsInsertRec("ID")
MM_editCmd.ActiveConnection.Close
that is, when UD 4 does its little insert, i want to move to the end of the
recordset (the new record we just inserted, which will be last one) and grab
that ID. but Access gives me the above error:
Rowset does not support fetching backward.
what dumb thing am i doing wrong?? tips, hints, etc. deeply appreciated!
tia,
fortune
----------------------------------------------------------------------------
--------------------
The views and opinions expressed in this email message are the sender's
own, and do not necessarily represent the views and opinions of Summit
Systems Inc.
More information about the thelist
mailing list