On 12/10/2023 12:11 PM EST wrote: Send lazarus mailing list submissions to 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 You can reach the person managing the list at 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 To: Lazarus mailing list Subject: Re: [Lazarus] Dbnavigator won't post to MSACESS db Message-ID: 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 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 > > https://lists.lazarus-ide.org/listinfo/lazarus ------------------------------ Message: 2 Date: Sun, 10 Dec 2023 17:07:12 +0100 (CET) From: Michael Van Canneyt To: Larry Dalton via lazarus Subject: Re: [Lazarus] Dbnavigator won't post to MSACESS db Message-ID: 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 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 >> >> https://lists.lazarus-ide.org/listinfo/lazarus > -- > _______________________________________________ > lazarus mailing list > > https://lists.lazarus-ide.org/listinfo/lazarus ------------------------------ Message: 3 Date: Sun, 10 Dec 2023 17:51:23 +0100 From: Bo Berglund To: Subject: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during build Message-ID: 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 To: Subject: Re: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during build Message-ID: 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: ------------------------------ Message: 5 Date: Sun, 10 Dec 2023 20:10:38 +0300 From: Mehmet Erol Sanliturk To: , Lazarus mailing list Subject: Re: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during build Message-ID: 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 < > 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 > > 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 https://lists.lazarus-ide.org/listinfo/lazarus ------------------------------ End of lazarus Digest, Vol 191, Issue 9 ***************************************