V4RB - UPDATE-Problem

[Ruslan Zasukhin]

On 2/10/05 6:02 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> Following works
> 
> 
>    cmd="SELECT RecID, Betrag from Buchungen"
>    CUR = tmpDB.SqlSelect(cmd, kV_Server, kV_NoLocks, kV_Random)
> 
>    ID=CUR.StringField("RecID")
>    Betrag = CUR.StringField("Betrag")
> 
>    Ende=CUR.RecordCount
> 
>    For i=1 to Ende
>      CUR.CurrentPosition=i
>      cmd="UPDATE Buchungen SET BetragHerk="+betrag.getstring+",
> BetragZiel="+betrag.getstring+" WHERE RecID="+ID.getstring
>      count=tmpDB.SQLExecute(cmd)
>    next
> 
> 
> but it is extremely slow :-((

Well, may be you will find interesting try V4RB 2.0 beta ?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------