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 "'" & cleanSQL (field tTicket) & "'" & "," after tRowBooking
>
> delete last char of tRowBooking
>
> put " UPDATE Booking set (ticket) = 'yes' where bookingID =
> tBookingID" & \
> " VALUES(null," & tRowBooking & ")" into tSQLbooking
So final SQL looks as:
UPDATE Booking
SET (ticket) = 'yes'
WHERE bookingID = 1
VALUES (null, 2)
?
I think you have mix INSERT and UPDATE syntaxes.
The correct update syntax is:
UPDATE Booking
SET ticket = 'yes'
WHERE bookingID = 1
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
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
