[Lazarus] lazarus Digest, Vol 191, Issue 9; DbNavigator Posting
john Ward
john at mbstemps.com
Tue Dec 12 23:11:57 CET 2023
I have experienced similar Problems, there doesn't seem to be an accurate connection between DbEdit fields used on a form and what is written to the Data Base. I have upper case on Fields but in the Data base (Dbase) the fields are lower case.
> On 12/10/2023 12:11 PM EST lazarus-request at lists.lazarus-ide.org wrote:
>
>
> Send lazarus mailing list submissions to
> lazarus at lists.lazarus-ide.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.lazarus-ide.org/listinfo/lazarus
> or, via email, send a message with subject or body 'help' to
> lazarus-request at lists.lazarus-ide.org
>
> You can reach the person managing the list at
> lazarus-owner at lists.lazarus-ide.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of lazarus digest..."
>
>
> Today's Topics:
>
> 1. Re: Dbnavigator won't post to MSACESS db (Larry Dalton)
> 2. Re: Dbnavigator won't post to MSACESS db (Michael Van Canneyt)
> 3. Lazarus 2.2.6 on Raspberry Pi5B, error during build (Bo Berglund)
> 4. Re: Lazarus 2.2.6 on Raspberry Pi5B, error during build
> (Maxim Ganetsky)
> 5. Re: Lazarus 2.2.6 on Raspberry Pi5B, error during build
> (Mehmet Erol Sanliturk)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sun, 10 Dec 2023 09:42:01 -0500
> From: Larry Dalton <larrydalton71 at gmail.com>
> To: Lazarus mailing list <lazarus at lists.lazarus-ide.org>
> Subject: Re: [Lazarus] Dbnavigator won't post to MSACESS db
> Message-ID: <522C0621-877F-4922-B700-60CD560DC87D at gmail.com>
> Content-Type: text/plain; charset=utf-8
>
> 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
>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 10 Dec 2023 17:07:12 +0100 (CET)
> From: Michael Van Canneyt <michael at freepascal.org>
> To: Larry Dalton via lazarus <lazarus at lists.lazarus-ide.org>
> Subject: Re: [Lazarus] Dbnavigator won't post to MSACESS db
> Message-ID: <e3ac358d-1b5e-1046-94f2-3df711cb5f7 at freepascal.org>
> Content-Type: text/plain; charset="utf-8"; Format="flowed"
>
>
>
> 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
>
> ------------------------------
>
> Message: 3
> Date: Sun, 10 Dec 2023 17:51:23 +0100
> From: Bo Berglund <bo.berglund at gmail.com>
> To: lazarus at lists.lazarus-ide.org
> Subject: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during build
> Message-ID: <j0mbni1p461m52u7i0s7qosr6oms1o8t1b at 4ax.com>
> Content-Type: text/plain; charset=us-ascii
>
> I am setting up my new RPi3B with 64 bit Pi-OS Bookworm and have now come to
> FreePascal/Lazarus.
>
> Freepascal is built from sources (trunk of 3.2.3) using a seed compiler 3.2.2
> earlier obtained as an apt install on an RPi4B also running Pi-OS 64 bit
> Bookworm.
>
> On this new system I want to build from sources to get everything inside my
> $HOME environment. That is why I did not install fpc 3.2.2 via apt.
> Fpc built just fine with these sources so that is how I got 3.2.3.
>
>
> Note that I am using fpc 3.2.3 head revision on this system since no other
> version seems to be possible to build on the 64 bit Pi-OS.
> But that version builds without problems.
>
>
> So I am using the self-compiled fpc 3.2.3 to build Lazarus 2.2.6 and it fails
> during build with the following exit message (only end of output shown):
>
> make bigide....
>
> (9009) Assembling translations
> (3104) Compiling uitypes.pas
> /home/bosse/devtools/lazarus/2.2.6/components/lazutils/uitypes.pas(105,14)
> Error: (3285) Expected another 2 array elements
> /home/bosse/devtools/lazarus/2.2.6/components/lazutils/uitypes.pas(93,58) Fatal:
> (10026) There were 1 errors compiling module, stopping
> Fatal: (1018) Compilation aborted
> make[1]: *** [Makefile:3394: lazutils.ppu] Error 1
> make[1]: Leaving directory
> '/home/bosse/devtools/lazarus/2.2.6/components/lazutils'
> make: *** [Makefile:3802: lazutils] Error 2
>
> This is how the file looks like at the location indicated:
>
> 62 interface
> 63
> 64 type
> 65 // Message dialog related
> 66 TMsgDlgType = (mtWarning, mtError, mtInformation, mtConfirmation,
> mtCustom);
> 67 TMsgDlgBtn = (mbYes, mbNo, mbOK, mbCancel, mbAbort, mbRetry, mbIgnore,
> 68 mbAll, mbNoToAll, mbYesToAll, mbHelp, mbClose);
> 69 TMsgDlgButtons = set of TMsgDlgBtn;
> 70
> 71 // ModalResult
> 72 TModalResult = low(Integer)..high(Integer);
> 73 PModalResult = ^TModalResult;
> 74
> 75 const
> 76 // Used for ModalResult
> 77 mrNone = 0;
> 78 mrOK = mrNone + 1;
> 79 mrCancel = mrNone + 2;
> 80 mrAbort = mrNone + 3;
> 81 mrRetry = mrNone + 4;
> 82 mrIgnore = mrNone + 5;
> 83 mrYes = mrNone + 6;
> 84 mrNo = mrNone + 7;
> 85 mrAll = mrNone + 8;
> 86 mrNoToAll = mrNone + 9;
> 87 mrYesToAll = mrNone + 10;
> 88 mrClose = mrNone + 11;
> 89 mrLast = mrClose;
> 90 {$ENDIF}
> 91
> 92 // String representation of ModalResult values
> 93 ModalResultStr: array[mrNone..mrLast] of shortstring = (
> 94 'mrNone',
> 95 'mrOk',
> 96 'mrCancel',
> 97 'mrAbort',
> 98 'mrRetry',
> 99 'mrIgnore',
> 100 'mrYes',
> 101 'mrNo',
> 102 'mrAll',
> 103 'mrNoToAll',
> 104 'mrYesToAll',
> 105 'mrClose');
> 106
> 107
>
> To me it seems like the number of elements is not in error...
>
> What can cause this failure and how can I solve it?
>
>
> --
> Bo Berglund
> Developer in Sweden
>
>
>
> ------------------------------
>
> Message: 4
> Date: Sun, 10 Dec 2023 20:01:15 +0300
> From: Maxim Ganetsky <ganmax at narod.ru>
> To: lazarus at lists.lazarus-ide.org
> Subject: Re: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during
> build
> Message-ID: <ed98629a-8520-4916-9383-85d333ef7265 at narod.ru>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> 10.12.2023 19:51, Bo Berglund via lazarus ?????:
> > I am setting up my new RPi3B with 64 bit Pi-OS Bookworm and have now come to
> > FreePascal/Lazarus.
> >
> > Freepascal is built from sources (trunk of 3.2.3) using a seed compiler 3.2.2
> > earlier obtained as an apt install on an RPi4B also running Pi-OS 64 bit
> > Bookworm.
> >
> > [...]
> >
> > Note that I am using fpc 3.2.3 head revision on this system since no other
> > version seems to be possible to build on the 64 bit Pi-OS.
> > But that version builds without problems.
> >
> >
> > So I am using the self-compiled fpc 3.2.3 to build Lazarus 2.2.6 and it fails
> > during build with the following exit message (only end of output shown):
> This combination of FPC and Lazarus won't work. You should use head
> revisions of Lazarus from `fixes_3_0` or `main` branches? if you want
> use FPC 3.2.3 and up.
> > make bigide....
> >
> > (9009) Assembling translations
> > (3104) Compiling uitypes.pas
> > /home/bosse/devtools/lazarus/2.2.6/components/lazutils/uitypes.pas(105,14)
> > Error: (3285) Expected another 2 array elements
> > /home/bosse/devtools/lazarus/2.2.6/components/lazutils/uitypes.pas(93,58) Fatal:
> > (10026) There were 1 errors compiling module, stopping
> > Fatal: (1018) Compilation aborted
> > make[1]: *** [Makefile:3394: lazutils.ppu] Error 1
> > make[1]: Leaving directory
> > '/home/bosse/devtools/lazarus/2.2.6/components/lazutils'
> > make: *** [Makefile:3802: lazutils] Error 2
> >
> > [...]
>
> --
> Best regards,
> Maxim Ganetsky mailto:ganmax at narod.ru
>
>
>
> ------------------------------
>
> Message: 5
> Date: Sun, 10 Dec 2023 20:10:38 +0300
> From: Mehmet Erol Sanliturk <m.e.sanliturk at gmail.com>
> To: bo.berglund at gmail.com, Lazarus mailing list
> <lazarus at lists.lazarus-ide.org>
> Subject: Re: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during
> build
> Message-ID:
> <CAOgwaMuvVf7kr9tq9QvV6v+NnZDE36oWxriLcYXo92ok_c56eA at mail.gmail.com>
> Content-Type: text/plain; charset="utf-8"
>
> There is a statement
>
> 90 {$ENDIF}
>
> Its outside of {$IFDEF } is not listed .
>
>
> It is very likely that
>
> mrNone..mrLast
>
> values are defined outside of ( IFDEF , ENDIF ) pairs .
>
>
>
> Mehmet Erol Sanliturk
>
>
>
>
> On Sun, Dec 10, 2023 at 7:59?PM Bo Berglund via lazarus <
> lazarus at lists.lazarus-ide.org> wrote:
>
> > I am setting up my new RPi3B with 64 bit Pi-OS Bookworm and have now come
> > to
> > FreePascal/Lazarus.
> >
> > Freepascal is built from sources (trunk of 3.2.3) using a seed compiler
> > 3.2.2
> > earlier obtained as an apt install on an RPi4B also running Pi-OS 64 bit
> > Bookworm.
> >
> > On this new system I want to build from sources to get everything inside my
> > $HOME environment. That is why I did not install fpc 3.2.2 via apt.
> > Fpc built just fine with these sources so that is how I got 3.2.3.
> >
> >
> > Note that I am using fpc 3.2.3 head revision on this system since no other
> > version seems to be possible to build on the 64 bit Pi-OS.
> > But that version builds without problems.
> >
> >
> > So I am using the self-compiled fpc 3.2.3 to build Lazarus 2.2.6 and it
> > fails
> > during build with the following exit message (only end of output shown):
> >
> > make bigide....
> >
> > (9009) Assembling translations
> > (3104) Compiling uitypes.pas
> > /home/bosse/devtools/lazarus/2.2.6/components/lazutils/uitypes.pas(105,14)
> > Error: (3285) Expected another 2 array elements
> > /home/bosse/devtools/lazarus/2.2.6/components/lazutils/uitypes.pas(93,58)
> > Fatal:
> > (10026) There were 1 errors compiling module, stopping
> > Fatal: (1018) Compilation aborted
> > make[1]: *** [Makefile:3394: lazutils.ppu] Error 1
> > make[1]: Leaving directory
> > '/home/bosse/devtools/lazarus/2.2.6/components/lazutils'
> > make: *** [Makefile:3802: lazutils] Error 2
> >
> > This is how the file looks like at the location indicated:
> >
> > 62 interface
> > 63
> > 64 type
> > 65 // Message dialog related
> > 66 TMsgDlgType = (mtWarning, mtError, mtInformation, mtConfirmation,
> > mtCustom);
> > 67 TMsgDlgBtn = (mbYes, mbNo, mbOK, mbCancel, mbAbort, mbRetry,
> > mbIgnore,
> > 68 mbAll, mbNoToAll, mbYesToAll, mbHelp, mbClose);
> > 69 TMsgDlgButtons = set of TMsgDlgBtn;
> > 70
> > 71 // ModalResult
> > 72 TModalResult = low(Integer)..high(Integer);
> > 73 PModalResult = ^TModalResult;
> > 74
> > 75 const
> > 76 // Used for ModalResult
> > 77 mrNone = 0;
> > 78 mrOK = mrNone + 1;
> > 79 mrCancel = mrNone + 2;
> > 80 mrAbort = mrNone + 3;
> > 81 mrRetry = mrNone + 4;
> > 82 mrIgnore = mrNone + 5;
> > 83 mrYes = mrNone + 6;
> > 84 mrNo = mrNone + 7;
> > 85 mrAll = mrNone + 8;
> > 86 mrNoToAll = mrNone + 9;
> > 87 mrYesToAll = mrNone + 10;
> > 88 mrClose = mrNone + 11;
> > 89 mrLast = mrClose;
> > 90 {$ENDIF}
> > 91
> > 92 // String representation of ModalResult values
> > 93 ModalResultStr: array[mrNone..mrLast] of shortstring = (
> > 94 'mrNone',
> > 95 'mrOk',
> > 96 'mrCancel',
> > 97 'mrAbort',
> > 98 'mrRetry',
> > 99 'mrIgnore',
> > 100 'mrYes',
> > 101 'mrNo',
> > 102 'mrAll',
> > 103 'mrNoToAll',
> > 104 'mrYesToAll',
> > 105 'mrClose');
> > 106
> > 107
> >
> > To me it seems like the number of elements is not in error...
> >
> > What can cause this failure and how can I solve it?
> >
> >
> > --
> > Bo Berglund
> > Developer in Sweden
> >
> > --
> > _______________________________________________
> > lazarus mailing list
> > lazarus at lists.lazarus-ide.org
> > https://lists.lazarus-ide.org/listinfo/lazarus
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20231210/dc1b2f34/attachment.htm>
>
> ------------------------------
>
> Subject: Digest Footer
>
> --
> _______________________________________________
> lazarus mailing list
> lazarus at lists.lazarus-ide.org
> https://lists.lazarus-ide.org/listinfo/lazarus
>
>
> ------------------------------
>
> End of lazarus Digest, Vol 191, Issue 9
> ***************************************
More information about the lazarus
mailing list