Jim Bentley-
I second the use of SQL Standard. Now I just ask myself if it is the SQL-92? Or SQL-99? Standard Oh heck what it might be tomorrow. SQL-10 Just funning also, these standands … and I was asked the other day what standard I was using and my reply was ‘RM’ in a true rational db setting. He didn’t ask anymore. Wish he did and I also found out that he was more Java then Db anyways. I guess looking for a weak point. Sincerely, Paul D www.SystemNets.com supporting doc/info: http://articles.techrepublic.com.com/5100-10878_11-1046268.html Oh ‘RM’ is the one and only Razzak M. and what he is using. I do not play with the settings. I figure RBTI spent years perfecting them and only run across mishaps with old code that I have and Format was not used and I set something and forgot or the person crash out and the settings got changed. I use a startup routine (one of Razzak’s) that set’s all those regardless of the cfg. Ever since then 1.5 yrs. No problems. Not sent by my iPhone4 Saving Lives - One Breath at A Time ™ "We cannot solve the problems we have created with the same rhinking that created them in the first place" Albert Einstein From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Thursday, June 24, 2010 2:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CFG file Jan, I am a big proponent of staying as close to the SQL standard as possible. The two settings of ON you cite does not conform to the SQL standard. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 _____ From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, June 24, 2010 11:32:23 AM Subject: [RBASE-L] - Re: CFG file Jim, I can only speak for myself and really can't make any recommendations on this setting. In my case I run with these 2 settings. SET ZERO ON SET EQNULL ON They have kept me out of the most trouble. However I'm sure that this will spark some dialog (disagreement) on this list. Jan -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 24 Jun 2010 11:19:29 -0500 Subject: [RBASE-L] - Re: CFG file Jan, I sure do appreciate your help. 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. I do need to create an actual application some day. That is quite hard to do when programming is part time. Is it true that having the ZERO setting OFF is the best way to go? We have many NULLS in our Quote entry, order entry processes, mostly because our users click in and out of only fields they need. As I said earlier, I just want the database information to be consistent and the speed to be the best. Jim _____ From: [email protected] [mailto: [email protected] ] On Behalf Of jan johansen Sent: Thursday, June 24, 2010 10:57 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CFG file 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" <[email protected]> To: [email protected] (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
