Re: Stored Procedures Help!!!

Hi Igor You've have discovered that concurence is real! I suggest you the following: create procedure xyz() set lock mode to wait; --this is the key put your code here end procedure; If you set the lock mode to wait when one user locks the table the other will wait until the table is unlocked. Then it will continue the execution of the procedure. Good luck! Dyrson > In article <39412bb9.95455456@news.ca.geac.com>, > i.sokolsky@geac.com (Igor) wrote: > > My Stored Procedure gets some information from a teble and return it > > to a client.When 3 clients run Stored rocedure in the same time we get > > following errors : > > (Error -107) ISAM error: record is locked > > (Error -243)Could not position with a table ( table_ name) > > > > Is that possible somehow to catch these errors and to return to a > > client some normal message ? Sent via Deja.com http://www.deja.com/ Before you buy.