upDate data

Devin Asay devin_asay at byu.edu
Fri Mar 24 14:17:39 EST 2006


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




More information about the Use-livecode mailing list