SQL Server CE can't parse my query (Insert and then select) -


i error when run query:

there error parsing query. [ token line number = 1,token line offset = 157,token in error = select ]

this use when writing while using 2008 r2...

here query:

insert tblexample([example], [groupid], [key], [value], [expectedcolumn])  values (@example, @groupid, @k, @v, @expectedcolumn); select @@identity; 

the execution:

if (db == null) { throw new exception("you must give me actiavted dbcon!"); } object ret = null; db.command.commandtext = query; addparameters(db.command, parameters);  if (db.connection.state != connectionstate.open)     db.connection.open();  var temp = db.command.executescalar(); if (temp != null && temp != dbnull.value) {     ret = temp; } return ret; 


Comments

Popular posts from this blog

plot - Remove Objects from Legend When You Have Also Used Fit, Matlab -

java - Why does my date parsing return a weird date? -

Need help in packaging app using TideSDK on Windows -