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.
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal