[Lazarus] Dbnavigator won't post to MSACESS db

[Larry Dalton]

Yes
Sent from my iPhone

> On Dec 10, 2023, at 09:42, Larry Dalton <larrydalton71 at gmail.com> 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.
> 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