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

2022-12-16 Thread Michael Van Canneyt via fpc-pascal
On Fri, 16 Dec 2022, Ondrej Pokorny via fpc-pascal wrote: Hello, I've got a similar problem about 2 days ago. I have a stored MSSQL procedure that changes a table. When it is run in SQL Managements Studio, the data get changed. When I run it with FPC, it runs fine but nothing changes. I

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

2022-12-16 Thread Michael Van Canneyt via fpc-pascal
On Fri, 16 Dec 2022, Andi Friess via fpc-pascal wrote: Am 16.12.2022 um 08:50 schrieb Michael Van Canneyt via fpc-pascal: ApplyUpdates as you use it, is not the correct solution. Once more: ApplyUpdates ONLY makes sense after changing data and doing a Post. Any other use does not make any sen

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

2022-12-16 Thread Ondrej Pokorny via fpc-pascal
Hello, I've got a similar problem about 2 days ago. I have a stored MSSQL procedure that changes a table. When it is run in SQL Managements Studio, the data get changed. When I run it with FPC, it runs fine but nothing changes. I do commit the transaction explicitly but the data isn't change

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

2022-12-16 Thread Andi Friess via fpc-pascal
Am 16.12.2022 um 08:50 schrieb Michael Van Canneyt via fpc-pascal: ApplyUpdates as you use it, is not the correct solution. Once more: ApplyUpdates ONLY makes sense after changing data and doing a Post. Any other use does not make any sense. Data is changed by the SP. But this is done in a simp