Wycliff Mabwai wrote: > syntax near "Where". > > SQLITEcmd2.CommandText = "UPDATE RecordGrid SET > LineNumber='" & reade20.GetInt32(11) & "',self_empty_info_gender_PRect= '" > & IIf(reade20.IsDBNull(22), String.Empty, reade20.GetString(22)) & "," & > IIf(reade20.IsDBNull(23), String.Empty, reade20.GetString(23)) & "," & > IIf(reade20.IsDBNull(24), String.Empty, reade20.GetString(24)) & "," & > IIf(reade20.IsDBNull(25), String.Empty, reade20.GetString(25)) & "' WHERE > RecordGridID='"chombo"'"
This is unreadable. Show the value of CommandText. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
