Devart Forums

Hi,

In my application, I do a DELETE for a table that has rows, but RowsAffected returns 0, can you confirm that?


With regards,

Martijn Tonies
Upscene Productions

RowsAffected works in TIBCSQL only if the component is prepared. This is a performance optimization.

Plash wrote:RowsAffected works in TIBCSQL only if the component is prepared. This is a performance optimization.

Please make it work when not preparing, there's hardly a point for the developer to prepare a statement manually when only executing something once and without parameters.


Thanks.


Martijn Tonies
Upscene Productions

You can use the TIBCQuery component instead of TIBCSQL. TIBCSQL is indended to obtain maximum performance. But actually its performance is approximately the same as that of TIBCQuery (if both of them query the count of rows affected).