I'm updating a record using the following (this is Sqllite for Excel)
RetVal = SQLite3PrepareV2(myDbHandle, "UPDATE data
SET ACTFINDATTIM = 'Data to save'
WHERE _id= " + CStr(Worksheets("Sheet1").Range("V5").Value),
myStmtHandle)
This works fine but when I try to change the String "data To Save" to the contents of a cell like follows
RetVal = SQLite3PrepareV2(myDbHandle, "UPDATE data
SET ACTFINDATTIM = '" + Worksheets("Sheet1").Range("H27").Value + "'
WHERE _id= " + CStr(Worksheets("Sheet1").Range("V5").Value), myStmtHandle)
Nothing Gets saved. Any Ideas where I'm going wrong?
Any Help Appreciated
Mark
Aucun commentaire:
Enregistrer un commentaire