Update SQlite database and run file in memory.
I have a database with more than 100,000 rows and I need to replace data in it all when I send any number that has anywhere in this database, I did tests and I have no error return, but the exchange is not done in the database either, can anyone help?
#include <SQLite.au3>
#include <array.au3>
Global $hQuery, $aRow, $sMsg, $sSql, $dados_linha
Global $BASE_DB, $cod_cartela, $sorteado, $retarr
_SQLite_Startup(@ScriptDir & "\sqlite3.dll")
Now I need to save what is in memory to the hard drive and I always have an error, can someone give a tip?
Local $dbdisk = _SQLite_Open(@ScriptDir & "\database.db")
_SQLite_Exec($dbdisk, "ATTACH DATABASE ':memory:' as Original;")
_SQLite_Exec($dbdisk, "CREATE TABLE Dados AS SELECT * FROM Original.Dados;")
I always get an error that the table was not found but in memory the table exists because it was created and populated.