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 <[email protected]> > *To:* RBASE-L Mailing List <[email protected]> > *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 > >
