Re: [fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Michael Van Canneyt via fpc-pascal
On Fri, 16 Dec 2022, Andi Friess via fpc-pascal wrote: Am 15.12.2022 um 14:59 schrieb Michael Van Canneyt via fpc-pascal: On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote: Post operation. No, if you use a stored procedure on the MSSQL Server there can be changes on tables. Withou

Re: [fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Andi Friess via fpc-pascal
Am 15.12.2022 um 14:59 schrieb Michael Van Canneyt via fpc-pascal: On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote: Post operation. No, if you use a stored procedure on the MSSQL Server there can be changes on tables. Without the ApplyUpdates these changes are not persitent. If you

Re: [fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Michael Van Canneyt via fpc-pascal
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote: Post operation. No, if you use a stored procedure on the MSSQL Server there can be changes on tables. Without the ApplyUpdates these changes are not persitent. If you close and reopen the connection ALL is lost. With ApplyUpdates it wo

Re: [fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Andreas Frieß via fpc-pascal
Am 15.12.2022 um 11:15 schrieb Michael Van Canneyt via fpc-pascal: On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote: On MSSQL i use a stroed procedure to count a value in a table and use the following statement in Lazarus 1.     procedureTForm1.BuExecuteClick(Sender:TObject); 2.    

Re: [fpc-pascal] debugserver and dbugintf

2022-12-15 Thread Michael Van Canneyt via fpc-pascal
On Wed, 14 Dec 2022, Rolf Wetjen via fpc-pascal wrote: Hi FPC team, I'm using FPC 3.2.2 as installed with Lazarus 2.2.4. I'm using the debugserver/dbugintf for some time and implemented some small changes to improve this duo. The files are attached. Changes to debugserver: - The name of

Re: [fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Michael Van Canneyt via fpc-pascal
On Thu, 15 Dec 2022, Andreas Frieß via fpc-pascal wrote: On MSSQL i use a stroed procedure to count a value in a table and use the following statement in Lazarus 1. procedureTForm1.BuExecuteClick(Sender:TObject); 2. var 3.   SQL:string; 4. begin 5.   Memo1.Clear; 6.  

[fpc-pascal] debugserver and dbugintf

2022-12-15 Thread Rolf Wetjen via fpc-pascal
Hi FPC team, I'm using FPC 3.2.2 as installed with Lazarus 2.2.4. I'm using the debugserver/dbugintf for some time and implemented some small changes to improve this duo. The files are attached. Changes to debugserver: - The name of the executable file is fpcdebugserver as this is the name d

[fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL

2022-12-15 Thread Andreas Frieß via fpc-pascal
On MSSQL i use a stroed procedure to count a value in a table and use the following statement in Lazarus 1. procedureTForm1.BuExecuteClick(Sender:TObject); 2. var 3.   SQL:string; 4. begin 5.   Memo1.Clear; 6.   SQL:=''; 7.   SQL:='EXECUTE [dbo].[GetNextZaehler] :TagN