none
SCOPE_IDENTITY() SqlCE Mobile problem RRS feed

  • Pergunta

  •  

    I unable to do the SCOPE_IDENTITY on a insert query at SQL Mobile.

     

    I need to perform on this query the insert on Client table and to get the ID.

    I am programming on Visual Basic on Visual Studio 2005

     

    My code is:

     

    Dim ClientID as Integer

    Dim sql As String = "INSERT INTO Client(Number) VALUES('5'); SELECT scope_identity()"

    Dim cmd As New SqlCeCommand(sql, connection)

     

    connection.Open()

    ClientID = Convert.ToInt32(cmd.ExecuteNonQuery())

    connection.Close()

     

    And I get an error like this:

     

    There was an error parsing the query. [ Token line number = 1,Token line offset = 76,Token in error = SELECT ]

     

    Thanks!

    terça-feira, 24 de abril de 2007 15:18

Respostas