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
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution