I am using lazarus v2.2.6 on Windows 11.
The form uses the following components:
  MBCCGator: TDBNavigator;
   MBCCGrid: TDBGrid;
   MBCCSource: TDataSource;
   MBCC_Connector: TODBCConnection;
   MBCCQuery: TSQLQuery;
   MBCC_Trans: TSQLTransaction;    MBCCQuery: TSQLQuery;
   also includes several TDBEdits.

It connects to an MSAccess Database, with a table named MBCC_2023. I have no trouble accessing the database, and reading the records. I can use MBCCGator to navigate the database. However, it will NOT post a new record or a changed record to the table. I don't get any error codes. It just won't store. Help is requested.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20231208/2661f958/attachment.htm>

Are you calling applyupdates and committing the transaction ?

Michael.

In my written code, yes. And I have no problems writing to the table that way. But using the Dbnavigator post button won?t work. Sent from my iPhone

Larry Dalton wrote

In my written code, yes. And I have no problems writing to the table that way. But using the Dbnavigator post button won?t work.

Then I suspect that is your problem.
The Dbnavigator post button only does a post, never ApplyUpdates and transaction commit.

The ApplyUpdates can be automated with the sqoAutoApplyUpdates option of the TSQLQuery, but the transaction commit should be implemented for example in the AfterApplyUpdates event.

Michael.

Yes
Sent from my iPhone

There is also sqoAutoCommit ...
L.