Re: [sqlite] Wanted - a straightforward 'grid' data entry tool for sqlite

Have you checked out "Base" from OpenOffice.org? If you want MS Access-like functionality, it might be worth a try. Note that Base uses HSQLDB as it's default backend, but you can replace it with SQLite Please see:

[sqlite] Foreign keys bypassed on insert?

Hello Sqlite-users! I have stumbled upon the fact that foreign keys are not always enforced. Specifically, that happened when I used the INSERT statement with a SELECT clause, which apparently caused invalid values to be inserted. How else would you explain the following?: PRAGMA