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!
You cannot have more queries in the same batch and scope_identity is not supported by SQL CE/Mobile. Use "SELECT @.@.IDENTITY" in a second .ExecuteNonQuery call.
No comments:
Post a Comment