[V4RB] API Equivalent of UPDATE WHERE

jda jda at his.com
Mon Jan 3 19:21:19 CST 2005


>
>
>UPDATE WHERE is more powerful command although, because I can do with it
>
>       SET f = f + 1 WHERE f > 10
>

Hm, is there a fast way to set the values of a numeric field to a 
sequence without looping through each record in a cursor? Say if 
there is 1000 records in the cursor, setting field id to

1
2
3
4
...
1000

I do that now, but as I said, I loop through each record in a cursor 
and set the value. It works, but gets kind of slow when there are 
5000-10000 records.

Jon


More information about the Valentina-beta mailing list