faustf Posted March 21, 2017 Share Posted March 21, 2017 hi guys , i try to update a sqlite db i create this script but i think the _SQLite_Exec is not correct , return not an error , but not upload the data Func _Sqlite3_Update($sDB, $sTable, $sColumn, $sDataSQL, $sColumFind, $Id_change) _SQLite_Startup() If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!" & @CRLF & @CRLF & _ "Not FOUND in @SystemDir, @WindowsDir, @ScriptDir, @WorkingDir, @LocalAppDataDir\AutoIt v3\SQLite") ; Exit -1 EndIf Local $DB = _SQLite_Open($sDB) If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a memory Database!") ;Exit -1 EndIf $SQLUPDATESTRING = "UPDATE " & $sTable & " SET " & $sColumn & " = " & _SQLite_Escape($sDataSQL) & " WHERE " & $sColumFind & " = " & _SQLite_Escape($Id_change) & ";" ConsoleWrite($SQLUPDATESTRING) _SQLite_Exec($sDB, $SQLUPDATESTRING) If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", _SQLite_ErrMsg(-1)) ;Exit -1 EndIf _SQLite_Close() _SQLite_Shutdown() EndFunc ;==>_Sqlite3_Update --> Press Ctrl+Alt+Break to Restart or Ctrl+Break to Stop UPDATE All_Cat SET depop_cat = '1_dalla cinta in su' WHERE id = '1'; anyone can help me?? Link to comment Share on other sites More sharing options...
faustf Posted March 21, 2017 Author Share Posted March 21, 2017 i correct a code now work Func _Sqlite3_Update($sDB, $sTable, $sColumn, $sDataSQL, $sColumFind, $Id_change) _SQLite_Startup() If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!" & @CRLF & @CRLF & _ "Not FOUND in @SystemDir, @WindowsDir, @ScriptDir, @WorkingDir, @LocalAppDataDir\AutoIt v3\SQLite") ; Exit -1 EndIf Local $DB = _SQLite_Open($sDB) If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "Can't create a memory Database!") ;Exit -1 EndIf $SQLUPDATESTRING = "UPDATE " & $sTable & " SET " & $sColumn & " = " & _SQLite_Escape($sDataSQL) & " WHERE " & $sColumFind & " = " & $Id_change & ";" ConsoleWrite($SQLUPDATESTRING) _SQLite_Exec(-1, $SQLUPDATESTRING) If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", _SQLite_ErrMsg(-1)) ;Exit -1 EndIf _SQLite_Close() _SQLite_Shutdown() EndFunc ;==>_Sqlite3_Update 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