UpDate Db

liamlambert liamlambert at mac.com
Fri Mar 24 07:19:03 EST 2006

I want to up date a column in a sqlLite db
the column is called ticket the table is called Booking
I want to update the column with the word YES

I have tried

put  "ticket" into tTicket

     put "'" & cleanSQL (field tTicket) & "'" & "," after tRowBooking

   delete last char of tRowBooking

   put " UPDATE Booking set (ticket) = 'yes' where bookingID =  
tBookingID"  & \
       " VALUES(null," & tRowBooking & ")" into tSQLbooking

   put revdb_execute(gConID,tSQLbooking) into tTmp
   handleRevDBerror tTmp
   if the result is not empty then
     answer warning the result
     exit mouseUP
   end if

Liam Lambert
liamlambert at mac.com

More information about the Use-livecode mailing list