[V4RB] API Equivalent of UPDATE WHERE

[Frank Schima]

Hi all,


With all this talk about the API way being faster than SQL, I was 
wondering what is the equivalent code for UPDATE... WHERE... with the 
new V4RB API?

UpdateRecord will update a single record, and UpdateAllRecords will 
update all the records of a table/cursor. So how can I update a subset 
of records without looping through them all and using UpdateRecord?

Basically I'm looking for an API workaround for that UPDATE SQL 
statement that is crashing for me. Namely:

    UPDATE MyTable Set MyVarcharField = 'some text' WHERE MyVarcharField 
is Null

Pseudo-code please? :^)


Best regards,
Frank