global gConID put fld "bookingid" into tbooking put "UPDATE Booking SET ticket = 'no' WHERE BookingId = 8 " into tSQLbooking --> EXECUTE SQL put revdb_execute(gConID,tSQLbooking) This works fine but if I want to use a variable in stead of 8 what is the syntaxes Liam Lambert liamlambert at mac.com IRELAND