Thanks Buddy, Tried that to no avail... there really _shouldn't_ be any nulls anyway. It's odd that the symptom comes and goes...
Ben Petersen On 14 Jun 2002, at 21:27, Buddy Walker wrote: > Ben > Is one of your columns null? You may want to set zero on. > > Buddy > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > On Behalf Of Ben Petersen > Sent: Friday, June 14, 2002 7:56 AM > To: [EMAIL PROTECTED] > Subject: Bogus Invalid Currency > > > Hi all, > > I have a choose statement I'm Struggling with. It includes a 5 table > join, and a where clause that includes > > ...and (t5.NetLocalBal+ t5.NetStateBal+ t5.NetNatlBal+ > t5.NetM1Bal+ t5.NetM2Bal+ t5.NetM3Bal+ t5.NetM4Bal+ > t5.NetInitBal+ T4.LateFeeDue-t6.CoreRec-t6.LateFeeRec) <> 0 ... > > Including a order by clause returns 'not a valid currency' error about > half the time... eliminating the above solves the problem, but that's > not an option. > > tia, > > Ben Petersen > > ================================================ > 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/ > > ================================================ > 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/ > ================================================ 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/
