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

[RVeitch_84]

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

[Denis_Segard]

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

Kind regards
Denis