[V4RB] API Equivalent of UPDATE WHERE

[Frank Schima]

On Jan 3, 2005, at 2:30 PM, Ruslan Zasukhin wrote:

>>> * Also your task CAN be made with UpdateAllRecords() as I see.
>>>
>>>     curs = db.SqlSelect(
>>>                 "SELECT MyVarcharField WHERE MyVarcharField IS NULL" 
>>> )
>>>
>>>     curs.VarCharField(x).valule = "someText"
>>>
>>>     curs.UpdateAllRecords()
>>
>> Well i have some records with text that i want to preserve because 
>> it's
>> different than 'some text'. I only want the NULL ones changed.
>
> Frank!
>
> But only NULL records will be selected in the cursor.
> So only they will be updated.

[Slaps head] Yes, of course - I get it now! Sorry for being dense (i.e. 
stupid). I'm so used to thinking in SQL terms and I'm trying to learn 
to use the nice new Valentina API more in place of SQL where possible 
for faster code.

:^)


Best regards,
Frank Schima