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@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@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
