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
[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
