Marc, Not strange at all, it goes with the territoty. I knew the answer because I deal with it often.
I guess I'm one of the curmudgeons who preferred life before NULL <> NULL and all that related stuff. But, you can't go back. <grin> Dennis -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Wednesday, October 15, 2008 2:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Very Strange From problem Leave it to me to have a strange problem. Is there an award for that?...or is it me causing strange problems? I should win that too. Thanks all Marc ----- Original Message ----- From: "Dennis McGrath" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, October 15, 2008 2:23 PM Subject: [RBASE-L] - Re: Very Strange From problem This looks like what happens where you have ZERO ON. RBASE sees numeric null as zero's. Even IFNULL is fooled thinking there is no null. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Wednesday, October 15, 2008 2:14 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Very Strange From problem Hi Alastair and Albert I think I found the problem, they had a custnum of 0 which seemed to mess up the lookup. It was as if the custnum field was null the expression defaulted to custnum 0. I kept seeing the same name show up without a custnum. So, I deleted custnum 0 then Unload ...Loaded and all seems well for now. Thanks Marc ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, October 15, 2008 1:28 PM Subject: [RBASE-L] - Re: Very Strange From problem > Different version of R:Base? Trying to do something that the older version > hasn't got.. > > Regards, > Alastair. > > > ----- Original Message ----- > From: "Marc" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Wednesday, October 15, 2008 6:57 PM > Subject: [RBASE-L] - Very Strange From problem > > >>I am working on a update routine to update several users >> databases. Of course this happens when I have a demo this >> weekend. >> >> I Delete all rows in Sys_forms3 then load the new forms. >> In one test database one of the forms has a problem in the >> expressions. I enter a custnum in a field in a region and the >> Name is displayed in a var in the region. >> >> This form has been working on my computer for months but >> when I ran a test update on a old database a user sent me it >> does not work correctly. >> >> I unloaded that form and loaded it in the problem DB, no help >> all the expressions are correct since it is the same form. >> >> I copied the "bad" db into the same folder with the good db >> thinking maybe some settings or other files were causing the problem. >> No luck, my db works but the bad db has the problem in the same folder. >> >> I compared the tables from the good and bad db and they are the same. >> Unload all....Still same problem. >> >> There has to be some silly thing I am missing but I can not think of >> anything >> else to check. >> >> Any suggestions? >> Marc >> >> > > > -------------------------------------------------------------------------------- > > > > No virus found in this incoming message. > Checked by AVG - http://www.avg.com > Version: 8.0.173 / Virus Database: 270.8.0/1726 - Release Date: 15/10/2008 > 07:29 > >
