Re: SET LOCK MODE TO WAIT ?

David, There is a SET LOCK MODE TO WAIT ?? where ?? is the number of seconds you want the system to wait. There is a SET LOCK MODE TO WAIT without any specification of time, also. And a SET LOCK MODE TO NOT WAIT command. I haven't played with the command much but I assume that if after the specified time to wait if the process cannot access the row it will cause an error. The SET LOCK MODE TO NOT WAIT is the default mode. Also, there is a SET ISOLATION command that you may want to consider. You can SET ISOLATION TO DIRTY READS if you are not to concerned with rows that might be in update mode. Other Isolation modes are: COMMITTED READ, CURSOR STABILITY, and REPEATABLE READ. Hope this helps, Jake -- ___ jake@pmafire.inel.gov ------------------| |---------------------- Jake Jacobson _______|__________________| | |____________ _________| LITCO |__________________________| | |____________|_________