Devart Forums

How can I find out immediately whether an INSERT or UPDATE operation has been successful, since they both return a Recordcount of 0.

For example,

sql := 'INSERT INTO table . . . '
execute;

Success := ??????


I guess I could trap the exception, but is there some other way?

Hello,

Besides exceptions, you can use the RowsAffected property, which is used to indicate the number of rows which were inserted, updated, or deleted during the last query operation. For more information please read the MyDAC documentation.

AndreyZ wrote:RowsAffected property.

Thanks, that's exactly what I wanted to know.

It is good to see that this problem was solved. If any other questions come up, please contact us.