Maybe you could use @@TRANCOUNT, because @@ROWCOUNT may not usable here (Help says that it resets to 0 by any SET command, or resets to 1 by simple variable assignment).
>Well, the help states that @@ROWCOUNT should work, however, it returned 1 in a field (similar to how COUNT works) and when I tried to use rollback (because @@ROWCOUNT was > 0) it returned the ODBC Err# 3903, (1526) The Rollback transaction request has no corresponding BEGIN TRANSACTION. So why did it return 1 then?
>
>
>
>>>Yes and I did not write it. I am just fixing what I can (as I find problems). Changing that would involve a change to the base classes... Don't even start... :o)
>>>
>>I see. Best of luck then! :)
>>
>>In the long run you may end up with a change in the base class, though. Otherwise you may have serious problems...
Edward Pikman
Independent Consultant