Recordset question

Results 1 to 2 of 2

Thread: Recordset question

  1. #1
    Join Date
    Dec 1969

    Default Recordset question

    Is it possible to refresh the records in a recordset to the latest data in a table?.Can I transfer a recordset cursor position from one recordset to another?.My problem occurs when saving a new record to my database, the table uses autonumber, so the recordset does not have the new autonumber, and I cannot look up the table without the number..All help AppreciatedCheersJ
    Starcraft 2 latest replays
    Last edited by Jay; 04-16-2011 at 01:14 AM.

  2. #2
    :) Guest

    Default RE: Recordset question

    You can use SELECT @@ IDENTITY to retrieve the autonumber from the newly added record.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts