tdbc::odbc: get count of deleted records

[Harald Oehlmann]

Using tclodbc, a "db {delete from table where state = 'old'}" would
return the number of deleted records.

With tdbc::odbc, a "db allrows {delete from table where state =
'old'}" returns nothing.

Is there any way to get the delete count ?
Or did I miss something ?

Thank you,
Harald

[Kevin Kenny]

The 'rowcount' method on the (empty) result set should return this.

'allrows' doesn't have a syntax to do it, so you have to go through
creating a statement and a result set.
--
73 de ke9tv/2, Kevin

[Harald Oehlmann]

Brilliant Kevin,
I will try.

Thank you,
Harald

[Harald Oehlmann]

I tried it today and it works:

% set s [::odbc::db prepare "delete from lookup where Article='AQ3B'"]
::oo::Obj62::Stmt::10
% set r [$s execute]
::oo::Obj81::ResultSet::1
% $r columns
% $r rowcount
1
% close $s