jeudi 28 janvier 2016

sqllite Update Statement Excel

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