> No, the function db_error will rollback the transaction.
> My Idea of posting this message is to know the difference in memory
> usage when I use Stored Procedures vs the direct updates. Now I am
> using direct update, the memory usage increase is low as compared to
> when I was using Stored Procedure. If you rememver we had a
> discussion with you in my last thread also. I had sent you code for
> the SP also.

there's no difference between using Stored Procedures Vs direct updates. I
can only imagine that there is a difference in how you have implemented each
alternative.
I can't comment fully on the embedded SQL you are using - I never use it.
Someone else will have to comment further
Alan