Hi,
I have sqlite3 database. I am able to open it and see the structure of the DB but I am not able to view or edit date in tables.
When I start SQLite Administrator on the right pane I see three tabs:
SQL Query, Result, Edit Data. But immediately after I open (oe reopen) my DB Edit Data tab vanishes.
- No problems with access rights for my DB file (Admin)
- SQLite version 3.3.10
- My DB was created with SQLite 3.3.8
I have tried to use your sqlite3.dll (version 3.3. but nothing positive happens.
When I use other tools for SQLite admin / management I have no problems.
This means that SQLite Administrator runs in "SafeMode" this occurs when Table/Field/Index/View etc ... names are containing invalid tokens.
See Errorlog for detail.
This is happening because ZeosDBO does not support all type of chars inside the name of database objects ... and it also will not work with indent brackets ( "[" name "]" ).
Hi Orbm2k,
I did some changes for a bug reported for mysql. As far as I remember this patch may impact sqlite behaviour as well. In mysql they use backticks instead of [, but maybe the [ problem is fixed. (See bug reports forum to see what changed exactly)
Oh no... Not completely. I think you should try to override GetIdentifierQuoteString of TZAbstractDatabaseMetadata in TZSQLiteDatabaseMetadata. (Default = double quote instead of []) See ADO implementation.
Can you test this? I don't use SQLite... When it works like that I'll modify our version immediately.
but nothing positive happens.
