[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