Hi Frank
>yes, you can have nested transactions. So if you start a new one and roll it back, then it won't affect your existing transactions.
Okay.
>Just out of interest, why are you trying to do this within a transaction that is running already?
What, start another transaction? That was because you suggested it to me *vbg*. Or a SELECT on the Table Buffered Remote View? Well that is becuase I have to only allow as much qty. for the items being enetered, so I was hoping to do a SELECT and find out the qty. already entered.
Anyway I have acheived the same using Non-SQL command.
Thanks for your responses.