<bg> What I meant was that if (Codebook you are using isn't it?) has a transaction running, why are you running code to total the quantity at this time? Shouldn't your code be before the Codebook (or whatever the framework is) transaction?
Another alternative is if it is that you are not allowed to sell more than you have in stock, use a rule on the table to ensure the qty field cannot be less than zero.
>>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.