[Lazarus] Dbnavigator won't post to MSACESS db

[Larry Dalton]

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

> 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