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