Daniel, I got rid of all my FILLIN commands. Perhaps it would be better if you could explain want needs to be accomplished instead of trying to fix this command.
Jan -----Original Message----- From: Daniel Lopez <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 30 Sep 2009 15:58:55 -0700 Subject: [RBASE-L] - Re: Changing data in one column deletes data in another....... i meant to say i really don't have very formal training with the language. i've pretty much just learned this stuff as i go thanks a bunch daniel On Wed, Sep 30, 2009 at 3:48 PM, Daniel Lopez <[email protected]> wrote: Sorry' let me give you some more background.... I'm using Rbase 7.6 on new machines running xp. The columns that follow in the where clause are all currency type but the columns i am calling are mixed date, text, currency...ect like i said before. if i change the command to "edit all from 'table' where.....so and so...' then there is no deletion. It is only when i get specific with the columns that i have a problem. i really have very formal training with the language so i may just be making a simple mistake but this macro worked before we converted to 7.6. On Wed, Sep 30, 2009 at 3:23 PM, Bernard Lis <[email protected]> wrote: Hi Daniel, Don't tell me, you are still on version 2.11???? if the col's are different type then, how can you use column eq .mm for all col's? Bernie Lis ----- Original Message ----- From: Daniel Lopez To: RBASE-L Mailing List Sent: Wednesday, September 30, 2009 5:51 PM Subject: [RBASE-L] - Changing data in one column deletes data in another....... Hey gang, I've made my best attempt at this one but any help will be greatly appreciated. What's happening is that when i change data in one column, the data in another column gets deleted. I've tried different configurations of the macro and an "edit all" macro works, (ie doesn't delete) but there are too many columns in the table and it is much more practical to be selective with what columns we edit. here is an example of the macro... _________________ clear var mm set variable mm currency fillin mm using 'bal = ' edit column1, column2, column3, column4, column5, column6.......ect........from (table) where (column1) eq .mm or (column2) EQ .MM or (column3) eq .mm or (column4) eq .mm ______________________ BTW... the column i am changing is a (date) type and the column being deleted is a (currency) type Any suggestion would be greatly appreciated Regards, Daniel
