#include #include #include Local $hQuery, $aRow, $aNames _SQLite _Startup ( ) If Then MsgBox ( 16, "SQLite Error", "SQLite3.dll Can't be Loaded!" ) Exit - 1 EndIf ConsoleWrite ( "_SQLite_LibVersion=" & _SQLite _LibVersion ( ) & ) Local $sDbName = "test.db" DB is in the same folder as the script Local $hDskDb = _SQLite _Open ( $sDbName ) Open a permanent disk database - this works fine _SQLite _Query ( - 1, "SELECT ROWID,1 FROM Test ORDER BY a ", $hQuery ) what am I doing wrong here? I get no such table: Test, Name, Value.what do I use here? If Then MsgBox ( 16, "SQLite Error", "Can't open or create a permanent Database!" ) Exit - 1 EndIf we can use the 3 database as needed by refering to their handle close the Dbs we created, in any order _SQLite _Close ( $hDskDb ) we don't really need that DB FileDelete ( $sDbName ) _SQLite _Shutdown ( ) In simply trying to run a query I keep running into an error: What I'm looking to do is simply delete some of the data in the values column. I know after this project is done I may not work with again for a long time due to other projects in the pipeline. Outside of today I have about zero experience with SQLite. I've been poring through the help file, goggling like mad and I'm no closer to being able to work with this thing. I know there is a column called "Name" and a column called "Value". I have an existing database called test.db.
0 kommentar(er)
