Re: Stored Procedures Help!!!

Hi Igor, You can use the ON EXCEPTION and RAISE EXCEPTION to catch these errors and return some meaningful message back to the app or calling function. For more infor refere to the SQL Syntax Guide. Don Igor wrote: > Hi All > > 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 ? > > Thanks > > Igor