[RBASE-L] - Re: CFG file

[jan johansen]

Jim,

I use the phrase from Highlander - "there can only be one".
In my situation (I use the compiler) the CFG lives in only one place, the 
shared server drive.
However critical database settings I can think of a couple of things I have 
done in the past.

1. Explore the ON CONNECT options. You can run a command file.
2. If you are using a form as a main menu, make a custom form action that 
has all the 
database settings that is called every time you connect i.e.
PROPERTY RBASE_FORM_ACTION DbSettings ""
in the form action we place the needed settings as such
--Required settings for database
SET ANSI OFF
SET BELL OFF
SET ROWLOCKS ON
SET QUOTES=NULL
SET QUOTES="
SET DELIMIT=NULL
SET DELIMIT=,
SET LINEEND=NULL
SET LINEEND=þ
SET SEMI=NULL
SET SEMI=;
SET PLUS=NULL
SET PLUS="+"
SET SINGLE=NULL
SET SINGLE="?"
SET MANY=NULL
SET MANY="*"
SET IDQUOTES=NULL
SET IDQUOTES="`"
SET CURRENCY "$" PREF 2 B
SET CASE OFF
SET AUTOSKIP OFF
SET REVERSE ON
SET NULL -0-
SET TOLERANCE 0.
SET ZERO ON
SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS
SET DATE SEQUENCE MMDDYYYY
SET DATE FORMAT MM/DD/YYYY
SET DATE YEAR 30
SET DATE CENTURY 19
RETURN

Good luck,

Jan
 


-----Original Message-----
From: "Jim Belisle" <j...@kaypark.com>
To: rbase-l@rbase.com (RBASE-L Mailing List)
Date: Thu, 24 Jun 2010 10:32:46 -0500
Subject: [RBASE-L] - CFG file


As is suggested, I always do my RELOAD on my local C drive.
Because of that, I have a CFG file on the C drive and a CFG file on the G 
drive where the database is located.
If these two CFG files happen to be different, will my session from my 
computer use the C drive CFG file instead of the G drive CFG?
 
I ask this question because of this:
We have had server problems lately that created problems with the database.
The only way I was able to get the database back to being healthy, was to 
play with the ZERO setting in the CFG file.
 
After the RELOAD last night, and after transferring my database back to the 
G drive, my ZERO setting was OFF which I believe is the setting suggested 
and the one I wanted.
This morning upon connecting, the ZERO setting is now ON. What should I do? 
I just don’t inconsistencies with my data.
 
Jim