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 <[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 >> >> >
