Sign in to follow this  
Followers 0
Marshin

SQLite Update command not working

3 posts in this topic

I am using the UPDATE command within _SQLite_Exec with the WHERE clause, but can't seem to get it to work.

if I leave out the WHERE clause then it update all the rows in the given column, but if I put it in it will not update any of them.

here is a how it looks with it in. :)

this does not work

_SQLite_Exec ($db, "UPDATE " & $DB_Table & " SET 'Description' = '" & $New_Description & "' WHERE 'PartNumber' = '" & $PartNumber & "';")

this updates all rows

_SQLite_Exec ($db, "UPDATE " & $DB_Table & " SET 'Description' = '" & $New_Description & "';")

any help on this would be great


At last, after two thousand years of research, the illudium Q-36 explosive space modulator.Well, back to the old drawing board.

Share this post


Link to post
Share on other sites



I've taken the single speach marks away from PartNumber so ry that if it fails it should bring up a message box with the sqlite error

If NOT _SQLite_Exec ($db, "UPDATE " & $DB_Table & " SET 'Description' = '" & $New_Description & "' WHERE PartNumber = '" & $PartNumber & "';") = $SQLITE_OK Then Msgbox(0,"", _SQLite_ErrMsg () )

Share this post


Link to post
Share on other sites

Thank you ChrisL it works just like it should :) . I thought for sure that I had tried that, but I guess not.


At last, after two thousand years of research, the illudium Q-36 explosive space modulator.Well, back to the old drawing board.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0