When I click POST on the DBNavigator the Form and controls refresh and everything is disabled and the record is not saved???
It's difficult to say what is going wrong here.
When working with transactional databases (what Firebird is) you
do need to handle transactions correctly.
If you didn't code anything and you just use the TDBNavigator... then a transaction is started.
But if you close the database (or your program) without committing the transaction, all changes will be lost.
The TSQLQuery has some options to do this automatically.
You can set sqoAutoApplyUpdates, sqoAutoCommit and sqoKeepOpenOnCommit in the options.
After doing that... you posts will stay in the database.
It is my understanding that sqlite does not support dates directly and requires a bit more work.
Actually... SQLite does support dates... but does not have specific date fields.
SQLite is a bit of an odd duck regarding SQL standards. It has few datatypes and in the TEXT field it can handle (and supports) different types of variables.
So SQLite can actually put dates in TEXT, REAL and INTEGER fields. And it supports those dates in those fields just fine. You just need to know how to handle them.
https://www.sqlite.org/datatype3.htmlFor simple single use database SQLite is the way to go. Although I prefer Firebird myself, because you can switch between 'embedded' and full server without changing anything in code. But if you are going to use Firebird (or other transactional database) you need to learn more about transactions.