AFAIK ~ isn't interpreted by the OS, but each program does the expansion. That's why you need absolute path instead.
Seems like, but that is to overcome, as long as one is aware.
However played a little more with a simple project:
Dropped on a form, very basic:
TSQLite3Connection
TSQLTransaction
TSQLQuery
TDatasource
TDBNavigator
TDBGrid
The grid is now populated with the values from the database, no problem.
However if I try to add another (using the navigator) record, it is added, but only in memory, so refreshing the database, and the new record is gone.
So are there any properties that have to be set (doing exactly the same with Zeos worked out of the box, but as said, Zeos unfortunately corrupts BLOBs, leaving that as a no-goer)?
Another thing, it seems like the above solution also locks the database - any suggestions?
Tnx
Christian