![]() I entered a newfile name including a folder, selected "add a database" and there was a button that said create, bit it takes me to the same screen as when I select "browse for I navigated to. Trouble creating a database was in sqlitestudio. The Delphi program is one I created, and it does nothing but on a button click connect to the sqlite connection, then open a table with a "select * from tablename". as you proceed in your investigation and obtaining help here. I would recommend the CLI shell as that tool because it will save a lot of typing and/or guessing about clicks, buttons, etc. I think you need to focus on exactly what file is being opened/modified by your program as a database, then use one reliable tool to see what is in fact happening to that same database. I do not see how that advances the investigation. ![]() You seem to be reporting that "dbbrowser for sqlite" works as you expect. There is a "commit changes" button which I hit and it appears to work because if I exit the program and come back in, the table is there. What makes you think your earlier "sqlite studio" session did not commit the table creation when you were able to select from the table? Did you explicitly open a transaction and never close it? I'm guessing not because that would have been a relevant fact for you to report. 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |