[RBASE-L] - Re: CFG file

[Jim Belisle]

RAZZAK,

I NOTICED WHEN YOU USE THE ZERO ON SETTINGS YOU ALSO SET THE NULL TO ' '
IF WE ARE USED TO THE NULL SETTINGS TO BE -0- WOULD IT BE BETTER TO USE
THE ZERO OFF SETTINGS?

I hope you will forgive what many I am sure consider basic questions.
I just want to make sure I do not run into the situation you referred to
below of messing with my routines.  

I always thought our settings were ZERO OFF.  It is only because of the
recent problems in the past few days that I even noticed it being ON.

So since we have been using the NULL -0- all this time thinking the ZERO
setting was OFF, would changing it as you show below create problems in
your opinion?  I do not have a preference, I just want guidance here. 

I might add that since we started using 7.6 a few years ago, this is
only the second time I have run into this particular problem.

Jim


-----Original Message-----
From: rbase-l@rbase.com [mailto:rbas...@rbase.com] On Behalf Of A.
Razzak Memon
Sent: Thursday, June 24, 2010 12:57 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: CFG file

At 12:19 PM 6/24/2010, Jim Belisle wrote:

>I do use a form instead of an application, mostly because Razzak
>helped me understand some of the 7.6 functions by implementing
>them into a form. I do have some ON CONNECT options, just not
>ALL the settings.

Jim,

Mucking with database SETtings and then wondering why some routines
are not working is pretty hard to keep track of. However, you may
adapt a routine in startup file that will always ensure consistent
results when connecting to your specific database(s).

Here is a code that you can use in your application startup file.
Make sure to update anything specific to your database environment.

-- Start here
-- Start Fresh
    CLEAR ALL VARIABLES
LABEL StartFresh
    DISCONNECT
    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
    DISCONNECT
    SET STATICDB OFF
    SET ROWLOCKS ON
    SET FASTLOCK OFF
    SET TIMEOUT 120
    SET FEEDBACK OFF
LABEL Start
    CLS
    CONNECT mydbname IDENTIFIED BY NONE
    -- Enforce Default Settings
    SET QUOTES='
    SET DELIMIT=','
    SET LINEEND='^'
    SET SEMI=';'
    SET PLUS='+'
    SET SINGLE='_'
    SET MANY='%'
    SET IDQUOTES='`'
    SET CURRENCY '$' PREF 2 B
    SET NULL ' '
    SET ZERO ON
    SET DATE FORMAT MM/DD/YYYY
    SET DATE SEQUENCE MMDDYY
    SET DATE YEAR 30
    SET DATE CENTURY 19
    CLS
    EDIT USING ApplicationMainMenu
    RETURN
-- End here

You may also save this routine as RBASE.DAT file, if you wish.

Hope it helps!

Very Best R:egards,

Razzak.