How to get the record count from an insert statement, MySql and tDBRow

RVeitch_84 — Thu, 02 Oct 2025 18:12:10 GMT

I have a basic job that insert records with a tDBRow and then I would like to get the results of the insert statement.

How many records where inserted with a, SELECT ROW_COUNT() as inserted_count

When I run this in MySQL workbench it works as expected, but in TS, its returning a -1

And I'm using a MySQL connection at the start and not closing it until the end.

I've tried getting the count with a tDBrow and a Recordset and also a tDBInput with the same result, -1.

Thanks for any help...

Bob

Re: How to get the record count from an insert statement, MySql and tDBRow

Denis_Segard — Fri, 03 Oct 2025 07:48:55 GMT

Hello,
Do you have a constraint to use tDBRow and not tDBOutput ?

Kind regards
Denis