update problems

[Ruslan Zasukhin]

On 3/25/05 9:53 PM, "Capra J'neva" <sonicinema at yahoo.com> wrote:

> Hi, sorry I just got the tail end of the conversation
> about updating, so sorry if this question has already
> been answered.  I am unable to make updates to a
> record.  When using the cursor script: UpdateRecord, I
> receive a #5 error (which means somehow that it cannot
> connect with a file) here is the script that causes
> the error: UpdateRecord(queryObject,"user",3) ...By
> the way a DeleteRecord in this same cursor position
> succeeds.
> 
> I used the following SqlExecute:
> SqlExecute(curDB,"UPDATE '" &baseObject&"' SET
> 'user'=3 WHERE 'numSizes'="&numSizes&" AND 'user'=2",
> 2, 3, 2)

    WHERE 'numSizes' = ..
        ^^^^^^^^^^^^^^

        this is field ?

    then why in quotes ?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------