[Lazarus] Dbnavigator won't post to MSACESS db

[Michael Van Canneyt]

On Sun, 10 Dec 2023, Larry Dalton via lazarus 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.

> Sent from my iPhone
>
>> On Dec 10, 2023, at 03:29, Michael Van Canneyt via lazarus <lazarus at lists.lazarus-ide.org> wrote:
>> 
>> 
>> 
>>> On Fri, 8 Dec 2023, Larry Dalton via lazarus wrote:
>>> 
>>> 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.
>> 
>> Are you calling applyupdates and committing the transaction ?
>> 
>> Michael.
>> --
>> _______________________________________________
>> lazarus mailing list
>> lazarus at lists.lazarus-ide.org
>> https://lists.lazarus-ide.org/listinfo/lazarus
> -- 
> _______________________________________________
> lazarus mailing list
> lazarus at lists.lazarus-ide.org
> https://lists.lazarus-ide.org/listinfo/lazarus