V4RB - UPDATE-Problem

[Claudius Sailer]

Hi Ruslan,

Am 01. Feb 2005 um 10:33 Uhr schrieb Ruslan Zasukhin:

> On 2/1/05 7:42 AM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:
>
>> Hi,
>>
>> is it possible that following Code doesn't work in V4RB 1.10
>>
>> UPDATE Buchungen SET BetragHerk=Betrag
>>
>> How can I do this when I need it?
>
> 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

Bye


Claudius

-- 
G4/733 QS / MacOS X 10.3.7de / RB 5.5.3de/ Valentina 1.10.0
Homepage	http://www.ClaSai.de
iChat		ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]