[RBASE-L] - RE: One of those "unexplainable" problems

[Javier Valencia]

Karen: Are you running the application from a server or do you have R:Base installed in the local workstations? Any chance that there is a stray rbase.cfg with the wrong settings lurking around in one of the local computers? Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, June 14, 2006 8:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - One of those "unexplainable" problems   A client is on combo of Windows & DOS 6.5++.  The startup application files changes, among other things:  SET ZERO ON  SET NULL ' ' after the database has been connected.  I've checked, and no other programs set zero OFF, nor set the null to -0-. App has been around for many years. Within the past couple months, all of a sudden forms come up with -0- in the null fields.  We ignored it as just weird. But then we found that when this happens, all the computed columns that happened to have a null value in the computation created null computed values!  They caught it when it happened, called me, and sure enough the ZERO is OFF.  And the Null was set to -0-. They CLAIM that this seems to happen if they are sitting in the main menu for a long time.  That the null was ' ' before they sat there, then the next time they did something the null was -0-.  And apparently the zero is now OFF.  The rbase.cfg files have those setings (off and -0-), but the startup file changes them!  I find it real hard to believe that the database settings at that user's workstation get changed without a program doing it!   Come on, explain this one to me! Karen