Marshin Posted May 9, 2008 Share Posted May 9, 2008 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. Link to comment Share on other sites More sharing options...
ChrisL Posted May 9, 2008 Share Posted May 9, 2008 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 () ) [u]Scripts[/u]Minimize gui to systray _ Fail safe source recoveryMsgbox UDF _ _procwatch() Stop your app from being closedLicensed/Trial software system _ Buffering Hotkeys_SQL.au3 ADODB.Connection _ Search 2d Arrays_SplashTextWithGraphicOn() _ Adjust Screen GammaTransparent Controls _ Eventlogs without the crap_GuiCtrlCreateFlash() _ Simple Interscript communication[u]Websites[/u]Curious Campers VW Hightops Lambert Plant Hire Link to comment Share on other sites More sharing options...
Marshin Posted May 9, 2008 Author Share Posted May 9, 2008 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now