I am new to cursor types. If you use a client side cursor (Access Database), and add a new record, the autonumber field value is NOT immediately available (shows null). Works fine with server side and I understand the logic. However, how do most people deal with this? If using a client side cursor, are we supposed to Requery and movelast after an addnew? This won't work with a sorted query always. How do people deal with this? When should one use server side as opposed to client side cursors? Also, the DED doesn't seem to allow server side cursors to work properly with access databases. I get an error when I run the command. If I create the recordset manually and set propertys manually in this recordset, I can do server side cursors (and get the autonumber field value immediately) but I would rather use a command in the DED. Its simpler. Less code etc. Anyone had this problem or know what I might be doing wrong in the DED with regards to server side cursors not working from it?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.