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