[V4RB] speeding up UPDATE statements

[Wonder Fef]

> 
> 1) myField1  -- is string field and you do replace of string ?
> 
> 2) am I right that you do this query for different myID ?

1) = YES (field is of type string(256))
2) = YES (this field is also a string(256))

The only time I had speed problem with Valentina was the bad choices type I
made for my fields...

>> I need to update several records (up to 1500 or more) in a go.
>> 
>> As far as I know, I can only do it through a loop of UPDATE statement sent
>> to the database with a SQLexecute. :
>> 
>> Do
>> 
>>   myValue1 = "some value"
>>   myValue2 = "more value"
>>   myID = "abc"
>> 
>>   statement = "UPDATE myTable SET myField1 = '" + myValue1 + "',
>>       myField2 = '" + myValue2 + "' WHERE ID = '" + myID + "'"
>> 
>>   if myDatabase.SQLexecute(Statement) <> 1 then
>>       ///
>>   end if
>> 
>> Loop until somethingMakesItExit
>> 
>> It works fine, but slowly on Mac and *desperately* slowly on Windows.
>> 
>> I'm using RealBasic v4.5.2 and Valentina PlugIn v.1.9.6