I try to
var sql = string.format ("if ( {0} & gt; (Select from yCell to sStrength, where cell_ID = '{1}')) ycell SET sStrength = {0} WHERE cell_id = '{1}' end ", Maxstrength, update to InSalead); SqlCeCommand myCommand = New SqlCeCommand (SQL, Connection); MyCommand.ExecuteNonQuery (); There is an error: Token Line Number = 1, Token Line offset = 1, error in error = if but it runs fine in SQL Studio.
Can not say why it is unsuccessful, but I can suggest that you might have a command Try updating in:
Update YCell SET sStrength {=} WHERE cell_id = '{1}' and {0}> Estrinth
No comments:
Post a Comment