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-requ...@lists.lazarus-ide.org wrote: > > > Send lazarus mailing list submissions to > lazarus@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-requ...@lists.lazarus-ide.org > > You can reach the person managing the list at > lazarus-ow...@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 <larrydalto...@gmail.com> > To: Lazarus mailing list <lazarus@lists.lazarus-ide.org> > Subject: Re: [Lazarus] Dbnavigator won't post to MSACESS db > Message-ID: <522c0621-877f-4922-b700-60cd560dc...@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@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 > > > ------------------------------ > > Message: 2 > Date: Sun, 10 Dec 2023 17:07:12 +0100 (CET) > From: Michael Van Canneyt <mich...@freepascal.org> > To: Larry Dalton via lazarus <lazarus@lists.lazarus-ide.org> > Subject: Re: [Lazarus] Dbnavigator won't post to MSACESS db > Message-ID: <e3ac358d-1b5e-1046-94f2-3df711cb...@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@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 > > ------------------------------ > > Message: 3 > Date: Sun, 10 Dec 2023 17:51:23 +0100 > From: Bo Berglund <bo.bergl...@gmail.com> > To: lazarus@lists.lazarus-ide.org > Subject: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during build > Message-ID: <j0mbni1p461m52u7i0s7qosr6oms1o8...@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 <gan...@narod.ru> > To: lazarus@lists.lazarus-ide.org > Subject: Re: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during > build > Message-ID: <ed98629a-8520-4916-9383-85d333ef7...@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:gan...@narod.ru > > > > ------------------------------ > > Message: 5 > Date: Sun, 10 Dec 2023 20:10:38 +0300 > From: Mehmet Erol Sanliturk <m.e.sanlit...@gmail.com> > To: bo.bergl...@gmail.com, Lazarus mailing list > <lazarus@lists.lazarus-ide.org> > Subject: Re: [Lazarus] Lazarus 2.2.6 on Raspberry Pi5B, error during > build > Message-ID: > <caogwamuvvf7kr9tq9qvv6v+nnzde36owxrilcyxo92ok_c5...@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@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@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@lists.lazarus-ide.org > https://lists.lazarus-ide.org/listinfo/lazarus > > > ------------------------------ > > End of lazarus Digest, Vol 191, Issue 9 > *************************************** -- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus