Re: locking problem

[Sam Spritzer <SSpritzer@GW.CTG.COM>]

Your "procedure something"....does it have BEGIN-SQL and END-SQL?

SQRly yours,
Sam

<<< Prashant Tupe <prashanttupe@HOTMAIL.COM>  9/10  2:30a >>>
Hi,
This is what I am doing....

select 
column list
            do something
from table

procedure something
delete rows from same table
end-procedure

When I use CTLibrary version of SQR4.3.4 I can not delete rows from that table because that table is locked. But when I use DBLibrary version of SQR4.3.4 I am getting output because of the different locking used by DBLibrary. I think both DBLib and CTLib use different kind of locking. 
Is there any way of changing the table locking in the program or at someother place so that I can do what I want to do? Is there any solution for this problem?
Waiting for reply..........
Thanks.......
Prashant.