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)
This works fine but if I want to use a variable in stead of 8 what
is the syntaxes
Liam Lambert
[EMAI
Ruslan
Thank You.
Liam Lambert
[EMAIL PROTECTED]
IRELAND
___
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
On 3/24/06 2:19 PM, "liamlambert" <[EMAIL PROTECTED]> wrote:
Hi Liam,
> 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 "'" & clean
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
