![]() ![]() I think you need fewer DB access tools, not more. At least this is consistent with the Delphi program,but the obvious problem is how to get sqlite studio to commit the table addition? On the database structure tab, it shows zero tables. I got a clue when I went into dbbrowser for sqlite and loaded in the new database file. Did that spelling include the whole, absolute pathname of the database file? I would guess not, and venture that if you specify an absolute pathname you will begin to see that your "sqlite studio" session and you "delphi program" session are not referring to the same database. ![]() 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. Was it the same as the one you created, attempted to create, or had trouble creating? This suggests you were able to create some database. Do you mean after attempting to create it? You had trouble "creating the database", yet after creating it, you saw some stuff. There is an ok button but it was greyed out.The only other button was a test button, and clicking that returns a green check mark. After creating and connecting to it, it stayed frozen on the creation screen. 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 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. ![]()
0 Comments
Leave a Reply. |