upDate data

[liamlambert]

What I want to do is to change Column ticket to where BookingId =  
tbookingID and change Column ticket to NO
what I am getting is changing column ticket to where column ticket = NO

Liam
On Mar 24, 2006, at 11:47 AM, liamlambert wrote:

 >  This works code works fine but if I want to use a variable  in
 > stead of 8
 > can I do this I could not find any reference to it any where
 > or is there an other way of up dating a column
 >
 >
 > 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)

Liam,

Do you mean that if you use:

global gConID
      put fld "bookingid" into tbooking
put "UPDATE Booking SET ticket = 'no' WHERE BookingId = '" & tBooking
& "'"  into
tSQLbooking
     --> EXECUTE SQL
     put revdb_execute(gConID,tSQLbooking)

it doesn't work? I've used this approach lots of times successfully.
What error message do you get back?

Devin

Devin Asay
Humanities Technology and Research Support Center
Brigham Young University

Liam Lambert
liamlambert at mac.com
IRELAND