Re: stored procedures

---- you wrote: > attached is the stored procedure and the table layout of the table that I am > trying to update. > I am getting a 201 : syntax error on the define x1 integer line. > Stored procedures are very new to me can any body help, > email: rob.smith@hhuncare.co.uk > or rob.smith@tinyonline.co.uk > > > create procedure rental_1() > -- Define user variables> define x1 integer default 1; Have you checked the manual Dude? Try this: define x1 integer; AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com