Thanks R:azzak, This is the information I needed. The start-up file does create these settings but I thought I would place a button in a particular portion of code to enable/disable messaging for debugging purposes. Look like it will work for a particular user without affecting other users, which is exactly what wanted to do.
Javier, Javier Valencia, PE O: 913-829-0888 H: 913-397-9605 C: 913-915-3137 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, February 19, 2013 11:04 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Tip of the Day: Database Stored Settings At 11:52 AM 2/19/2013, Javier Valencia wrote: >R:azzak, >I was just going over settings as I am trying to implement error >catching code and I was trying to determine if: >SET MESSAGESON >SET ERROR MESSAGES ON >Were local or database wide settings; i.e. if I add the commands above >to a procedure, will it enable it to other users or will it be >restricted to the current user? >I did not see them in your list so I take it that they work at the >current user level only. Javier, SET MESSAGES ON/OFF and SET ERROR MESSAGES ON/OFF settings are R:BASE session specific settings. My time & schedule permitting, the next topic will explain those settings in details. Having said that, if your startup command or DAT file enforces those settings, then all users/R:BASE sessions connected to the same database, using the same startup command or DAT file will use same settings. Hope that explains. Very Best R:egards, Razzak. >-----Original Message----- >From: [email protected] [mailto:[email protected]] On Behalf Of A. >Razzak Memon >Sent: Tuesday, February 19, 2013 10:36 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - Tip of the Day: Database Stored Settings > >Tuesday, February 19, 2013 > >Tip of the Day: Database Stored Settings >Product: R:BASE eXtreme 9.5 (32/64) >Build..: 9.5.2.20128 or higher www.rupdates.com >Section: Settings, Configuration, Database >Topic..: Settings Stored in the Database Files > >Did you know that there are several R:BASE settings that are stored >within the database files, which are automatically applied to any other >R:BASE instance when it connects to that same database? > >These are called Database Stored Settings. > >The following is a list of R:BASE Database Stored Settings: > >CHARacter Settings: > BLANK > DELIMIT > LINEEND > SEMI > QUOTES > PLUS > SINGLE > MANY > IDQUOTES > NULL > >DATE Settings: > DATE FORMAT > DATE SEQUENCE > CENTURY Threshold > Default CENTURY > >TIME Settings: > TIME FORMAT > TIME SEQUENCE > >CURRENCY Settings: > CURRENCY SYMBOL > CURRENCY LOCATION > CURRENCY DIGITS > CURRENCY CONVENTION > >Operating Conditions: > AUTOSKIP > BELL > CASE > REVERSE > TOLERANCE > ZERO > >Database Events: > ON ERROR > BEFORE PACK > AFTER PACK > BEFORE CONNECT > AFTER CONNECT > FIRST CONNECT > >Stay productive, my friends! > >Very Best R:egards, > >Razzak. > >www.rbase.com >www.facebook.com/rbase >www.RazzakMemon.com
