UpDate Db

[Ruslan Zasukhin]

On 3/24/06 2:19 PM, "liamlambert" <liamlambert at mac.com> 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]