[fpc-pascal] SqlDB TSQLQuery sqoAutoApplyUpdates does not work with ExecSQL
Ondrej Pokorny
lazarus at kluug.net
Fri Dec 16 09:36:49 CET 2022
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?
I'll check it again.
Ondrej
More information about the fpc-pascal
mailing list