Create sqlite database using sqlitestudio

#Create sqlite database using sqlitestudio how to

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

#Create sqlite database using sqlitestudio how to

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 had trouble creating the database in sqlite studio. 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.

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.