I had trouble creating the database in sqlite studio. SQLite database files have a platform-independent format. db file on the win10 computer.Īn incorrect guess. I made a guess that since the database file was created on a win7 computer, and now I am on a newer Win10 computer, that maybe I need to create the. Is it a Delphi program you created? If so, what was it doing? If not, would you not suspect that its identity would help others see what might be wrong? First, the program would fail with a 'data exception' error, followed by a long hex number. I am having trouble getting a Delphi program to use sqlite. I copied the file sqlite3.dll to the same folder of the database file, but same results. If I exit the program and come back in, the table is there. There is a 'commit changes' button which I hit and it appears to work because On the database structure tab, it shows zero tables.Īt least this is consistent with the Delphi program,but the obvious problem is how to get sqlite studio to commit the table addition? I got a clue when I went into dbbrowser for sqlite and loaded in the new database file. I checked the spelling and it is correct.

The bad news is it tells me there is no such table. I reran the delphi program and the good news is there was no external error. I ran a select * on the new table and the data is there. I then created a table and wrote sql code to insert a record. There is an ok button but it was greyed out.The only other button was a test button, and clicking that returns a I am having trouble getting a Delphi program to use sqlite.įirst, the program would fail with a 'data exception' error, followed by a long hex number.

Sqlitestudio no upper case letters