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
