Aha! The setting is stored in the DB! Perfect! Thanks, Razzak, for the info.
Dennis McGrath From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, February 17, 2015 12:26 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding error Similar to NULL, DATE, TIME, CHAR, the new NOCALC setting is relevant to the connected database. -- Example CONNECT dbname SET NOCALC ON DISCONNECT EXIT Start RBG95 CONNECT dbname SHOW NOCALC (CVAL('NOCALC')) will reveal the current setting for NOCALC. That's your tip of the day! Enjoy! Very Best R:egards, Razzak On Tue, Feb 17, 2015 at 12:31 PM, Dennis McGrath <[email protected]<mailto:[email protected]>> wrote: Interesting…. Version 9.5.5.20214 I added these to my config file. NOCALC ON CHECKPROP ON Start RBASE NOCALC is OFF CHECKPROP is ON It looks like NOCALC does not work in the config file. Dennis McGrath From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of jan johansen Sent: Friday, February 13, 2015 5:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding error NOCALC and CHECKPROP -----Original Message----- From: Dennis McGrath <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> (RBASE-L Mailing List) Date: Fri, 13 Feb 2015 15:40:20 -0600 Subject: [RBASE-L] - RE: Finding error What has been added to the config file? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, February 13, 2015 12:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Finding error Dan, Perhaps I shouldn't have said "needs". Since there are two new environment settings and a new config file, I felt it would be prudent to do a database unload before a reload. Jan -----Original Message----- From: Dan Goldberg < [email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> (RBASE-L Mailing List) Date: Fri, 13 Feb 2015 18:00:20 +0000 Subject: [RBASE-L] - RE: Finding error Try unloading the problem table and looking at the data in excel or notepad. I am wondering why you said with the most recent update you need to do a complete unload/reload? The reason I am asking is two of my databases got corrupted shortly after the update. I did an unload/reload and they have been fine since. That way I am not looking for a bad NIC or something else that caused the corruption. Thx Dan Goldberg From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of jan johansen Sent: Friday, February 13, 2015 9:37 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Finding error Group, Because the most recent update really needs your database to do a complete unload and reload, I've come across a couple of problems (stress these are problems with my data). During the reload I receive numerous errors of ONE specific problem, COLUMN mycolumnname must be valid DOUBLE. Fine. Then I search the column and fix the data and unload again. I've searched on that column looking for stuff like a text or something but not really seeing a problem. How would I query the database looking for an invalid value in that column? Jan
