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]>
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]] *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]>
> To: [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] <[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]>
> To: [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] <[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
>
>
