[V4MD 2] update only one field in a loop

[Ruslan Zasukhin]

On 5/31/05 9:11 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

Hi Paolo,

> Hi Ruslan,
> if I need to update only a field of DB for n records what is the better way?
> 
> e.g.
> repeat with i = 1 to recCount
> gCursor.field("F1").value = member("F1").text
> gCursor.updateRecord() -- LOOK HERE
> end repeat
> 
> In your docs I read the word nil
> I know null but nil... what means?

1) pure SQL way:

    UPDATE T SET ... WHERE ...



2) Cursor API way

    curs.Field( "F1" ).value = ..
    curs.UpdateAllRecords()

    Will be updated all records of cursor
    by the same value.


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