[Lazarus] Dbnavigator won't post to MSACESS db

[LacaK]

>
>
>
>> 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.

There is also sqoAutoCommit ...
L.

>
> 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
>