V4RB - UPDATE-Problem

[Ruslan Zasukhin]

On 2/9/05 9:07 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> You try assign one field to another ?
>> 
>> In the worse can you can write loop to do this.
> 
> could you give me a short hint?
> tmpDB is VDatabase
> 
> following doesn't work
>    cmd="UPDATE Buchungen SET BetragHerk=Betrag"
>    count=tmpDB.SQLExecute(cmd)
> 
> how can I update new field?
> Do you have some exampleCode?
> 
> normally I am working with mydatabase = new database but this is not
> defined at this step and moment. How can I make Update-routine with
> tmpDB? I have at the moment no idea!!
> 
> Thanks for help

Hi Claudius 

    curs = SqlSelect "SELECT ... WHERE ... "

    f1 = curs.field("f1")
    f2 = curs.field("f2")

    do
        f1 = f2    
        curs.UpdateRecord

    while curs.nextRecord

    db.Flush()

-- 
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
-------------------------------------------------------------