Pervasive
Sign in | Join | Help
in
Pervasive Community Site » Legacy Software » Pervasive.SQL 2000 SDK » SDK Technical » Retrieving Identity from Recordset

Retrieving Identity from Recordset

Last post 07-17-2008 8:52 AM by jpruneda. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 05-22-2002 11:00 AM

    Retrieving Identity from Recordset

    Reply Contact
    I need to retrieve an identity value automatically created imediately after an add new/update in VB.
    According to all texts its not a problem,
    as the ID is created upon the Addnew.
    However i cannot seem to get the value to return when using the Pervasive ODBC Engine.
    Is an identity assigned imediatley upon the addnew in Pervasive so as i can retrieve the value without requerying my recordset?

  • 07-16-2008 8:25 PM In reply to

    Re: Retrieving Identity from Recordset

    Reply Contact
    I have the same problem, only there is nothing unique to requery with in my case...

  • 07-17-2008 8:52 AM In reply to

    Re: Retrieving Identity from Recordset

    Reply Contact

    To get the last identity, there is a statement:

    Select @@identity 

    More complete information for this is in the SQL Reference manual.
Page 1 of 1 (3 items)
© 2008 Pervasive Software Inc. All Rights Reserved.