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
