[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