Updating all records again

[Roger Amar]

Hi Ruslan,

The SQL command does not work at all.
Database_SQLExecute returns the number of raws affected, but no change is made.

I checked that I have no "unique" field.
At this time I tried all of the suggestions of the archive list with no success.

Since updating one record is working, I can update within a loop, but it takes a lot of time.

What is wrong at your opinion ?

Thanks for your help,

Best regards,

Roger;




-----Message d'origine-----
De : valentina-bounces at lists.macserve.net [mailto:valentina-bounces at lists.macserve.net] De la part de Ruslan Zasukhin
Envoyé : jeudi 24 février 2005 14:03
À : valentina at lists.macserve.net
Objet : Re: Updating all records again

On 2/24/05 11:57 AM, "Roger Amar" <Roger at logram.com> wrote:

Hi Roger,

> Just now, I have a new problem : when I attempt to update all the 
> records of a cursor, they are *not* updated.
> 
> My handler is made like this :
> 
> on UpdateAllRecords fldName, fldValue
>     CheckdbRef
>     CheckCursor
>  
>     put Valentina("Cursor_SetField",cursorRef,fldName,fldValue) into 
> temp --> returns empty
>     CheckError "UpdateAllRecord", "Cursor_SetField", temp
>  
>     put Valentina ("Cursor_UpdateAllRecords",cursorRef) into temp --> 
> returns true
>     CheckError "UpdateAllRecords", "Cursor_UpdateAllRecords", temp
>  
>     put Valentina ("DataBase_Flush",dbRef) into temp --> returns empty
>     CheckError "UpdateAllRecords", "DataBase_Flush", temp end 
> UpdateAllRecords
>  
> What is wrong ??

Looks to be correct.

Hmm, you can try to use SQL command

    UPDATE T SET fldname = value WHERE ...


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


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina