V4RB - UPDATE-Problem

[Claudius Sailer]

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 ?

detailed coding is

   //Felder bei Buchungen hinzufuegen
   cmd="ALTER TABLE Buchungen ADD BetragHerk LONG NOT NULL"
   count=tmpDB.SQLExecute(cmd)

   cmd="ALTER TABLE Buchungen ADD BetragZiel LONG NOT NULL"
   count=tmpDB.SQLExecute(cmd)


   //Auf Ausgangswert setzen
   cmd="UPDATE Buchungen SET BetragHerk=Betrag"
   count=tmpDB.SQLExecute(cmd)

   cmd="UPDATE Buchungen SET BetragZiel=Betrag"
   count=tmpDB.SQLExecute(cmd)

problem is, that I want to move from one currency application to multi 
currency. In a first step all accounts are EUR accounts. Now I want to 
copy all EUR values to the account values ;-))

> In the worse can you can write loop to do this.

Not really good, but it seems this will be the way :-((

Thanks



Claudius

-- 
G4/733 QS / MacOS X 10.3.7de / RB 5.5.3de/ Valentina 1.10.0
Homepage    http://www.ClaSai.de
Download    finale Versionen, Betaversionen auf der Homepage
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]