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
Post a Comment