ExecSQL Result

[MatthewB]

Using a TMyQuery to UPDATE a record, i need to verify that the ExecSQL successfully performed the update.
I.e. that it found the record and made the update or how many records it did update
some Result := ExecSQL (Boolean or Integer result)
thanks

[davidmarcus]

If you use TMyCommand, there is a RowsAffected property.

[ViktorV]

As davidmarcus wrote correctly to solve the problem, you can use the TMyQuery.RowsAffected property: https://www.devart.com/mydac/docs/devar ... fected.htm

[MatthewB]

Thanks!

[ViktorV]

Thank you for the interest in our products.
Contact us if you have any questions about our products.