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

[Michael Van Canneyt]

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 do commit the 
> transaction explicitly but the data isn't changed anyway. Do I need to run 
> ApplyUpdates as well? Isn't a commit enough?

The commit should be enough.

Once more: 
ApplyUpdates is ONLY for when you change data in the dataset.

Michael.