SCOPE_IDENTITY() SqlCE Problem

[jonnycage]

I am 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!

[petevick]

Hi,
you can't string multiple commands together in SqlMobile

Pete

[jonnycage]

Thank's! Problem resolved! I just had to separate my query in two querys!