Note: Due to Forum size limits, 'sqlite3.dll' was removed from the project file. I also had to rename 'TestAccount.sql' to '.txt'.So I've been learning SQL and how to use it with Lazarus in hopes to make my own personal accounting software.
Mainly just for fun and learning. So nothing I plan on releasing.
(I'm no accountant, so watching my own spending is fine, cause if I screw up then its only me.
)
So I typed up my own sql file for spending and such, then saved it as a database using SQLite Tools and used the attached project to view the file and ...it turned out kind of like the attached pic.
Now, i'll admit the attached project code is a little bit of a mishmash of stuff I pulled off the net/forms and such, but it opens other SQLite database files that I had for testing (Like Chinook and a D&D3.5 SRD Database).
Then when I went to open mine, ...well, It doesn't really work.
So, I created this TestAccount.db and viewed it with the attached project and it does the same thing.
TestAccount.db was made using the TestAccount.sql file attached below and saved as a Database with SQLite Tools.
A program called
SQLite Control Center also opened my TestAccount.db just fine and using the attached sql file in SQLite Control Center to create a Database gives the same results.
So can someone tell me where I'm screwing this up?
or point me to something that'll help.
...Though I'll say that finding tutorials for SQLite and Lazarus/Free Pascal is ...difficult. So I may have missed something.
(Plus limited internet doesn't help...)
...oops, forgot: I'm on WinXP with Lazarus 1.6.4