G-Day Tom, You hit the nail on the head... The funny thing about this is that this formula was defined years ago, and put into working around version 3.x -- before my time... It has been working and when I upgraded from 4.5 to 6.0 it kept the formula without any complaints.. It's only when I went from 6.0 to 6.5 that it mystically dropped the formual without any warnings... We tracked down by the records in the database when this functionality stopped working and the last recorded date that this worked was a few days before our upgrade. The upgrade must have dumped the formula without telling us... ouch...
After shifting the column and accumulated data for this column it works just dandy... Thank You Jim Limburg :) --- Tom Grimshaw <[EMAIL PROTECTED]> wrote: > G'day Jim, > > No, not crazy, just illogical. :-) > > Out sequence is the illogic. > > The referenced column must precede the referencing column. > > At 13:44 14/03/02 -0800, you wrote: > >OK > > > >Am I crazy or what??? Don't answer that... > > > >In RBase Dos 6.5++ I want to add an expression to > >tables column, I don't remember how in the dos version > >so I took the db to the directory for my windows > >version and attempted it there and I got back this > >error: Column or variable USESELLPR not found (2515) > > > >The expression I want to put in for the column - SELLPR is: > > > >(IFEQ(USESELLPR,'Y',(SELLPR * 2),NULL)) > > > > > >Here is the part of the output of the list table poitems command > > > > 16 SELLPR Type : > > CURRENCY > > Default: > > 0.00 > > Comment: SELLING > > PRICE > > 17 USESELLPR Type : TEXT > > 1 > > Comment: USE SELLING PRICE FLAG > > > >What am I doing wrong? > > > >TIA > >Jim > > > >__________________________________________________ > >Do You Yahoo!? > >Yahoo! Sports - live college hoops coverage > >http://sports.yahoo.com/ > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > >================================================ > >TO SEARCH ARCHIVES: > >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > Warmest regards, > > > Tom Grimshaw > coy: Just For You Software > tel: 612 9552 3311 > fax: 612 9566 2164 > mobile: 0414 675 903 > > post: PO Box 470 Glebe NSW 2037 Australia > street: 3/66 Wentworth Park Rd Glebe NSW 2037 > > email: [EMAIL PROTECTED] > web: www.just4usoftware.com.au > > This email and any files transmitted with it are confidential to the > intended recipient and may be privileged. If you have received this email > inadvertently or you are not the intended recipient, you may not > disseminate, distribute, copy or in any way rely on it. Further, you should > notify the sender immediately and delete the email from your computer. > Whilst we have taken precautions to alert us to the presence of computer > viruses, we cannot guarantee that this email and any files transmitted with > it are free from such viruses. > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.com/ __________________________________________________ Do You Yahoo!? Yahoo! Sports - live college hoops coverage http://sports.yahoo.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
