Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index

Startup Files

Scroll Prev Top Next More

A startup file is a command file that executes automatically when you launch R:BASE, such as CUST.DAT. A startup file for a custom R:BASE application ensures that users start the application the same way each time. The startup file is usually included in the same directory as the database and application files to start R:BASE, specify settings for the custom application, set up certain environment variables, enter passwords, create temporary tables, and/or close R:BASE when the application is closed.

 

A startup file can be an R:BASE command file (.DAT, .RMD, .CMD) or an R:BASE application file (.RBA).

 

Startup files can be specified in two ways:

 

1.Desktop Shortcut Properties

 

Within the "Target:" field of a desktop icon's shortcut properties, you can specify a startup file. Specify your startup file in the "Target:" field after the R:BASE executable name. Then, separate the R:BASE executable and startup file with a space.

 

2.R:BASE Configuration File

 

Inside the configuration file a startup file can be specified with the STARTUP parameter. This tells R:BASE to run the specified file when launched. To specify a startup file in the configuration file, you can edit the configuration file directly, or use the "Display" tab within the R:BASE Configuration Settings dialog. To access the Configuration Settings dialog, choose "Settings" > "Configuration Settings" from the main menu bar.

 

To edit the configuration file directly, start the R:BASE Editor and open the configuration file.

 

Before the OPTIONS parameter, insert the line STARTUP filespec. For example:

 

;============================================================

; Launch on Startup

;============================================================

MENU

STARTUP     C:\RBTI\RBG11\MainData\NewSet.dat

OPTIONS

 

Notes:

 

If a startup file is specified in both the configuration file and the desktop shortcut, R:BASE executes the commands in the startup files specified in the configuration file first, then any file specified after the R:BASE executable.

 

If an RBASE.DAT file is located in the "start in" or "working" directory upon launching R:BASE, the program will always automatically run this file.

 

Do not include the following commands in a startup file:

 

GATEWAY

ZIP ROLLOUT

 

If you are using CodeLocked procedure files (APP, APX) as the source for your R:BASE custom application, you would create an R:BASE startup file to initialize the procedure file. The startup file would only require two commands, RUN and EXIT:

 

RUN appname IN appname.apx

EXIT

 

Examples:

 

Example 01:

 

--CONCOMP.DAT

--ConComp Application Startup file using a form as the menu system

IF(CVAL('DATABASE')) <> 'CONCOMP' OR (CVAL('DATABASE')) IS NULL THEN

 CONNECT CONCOMP IDENTIFIED BY NONE

ENDIF

CLS

EDIT USING MenuForm

EXIT

 

Example 02:

 

--CONCOMP.DAT

--ConComp Application Startup file using codelocked files as the menu system

RUN CONCOMP IN CONCOMP.APX

EXIT

 

Example 03:

-- Automates the process of CONNECTing to a database in a network environment with SET STATICDB ON, SET FASTLOCK ON, SET ROWLOCKS ON, and SET PAGELOCK OFF.

 

-- MyApp.DAT Startup Application File

-- 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 ON

SET ROWLOCKS ON

SET FASTLOCK ON

SET PAGELOCK OFF

SET MESSAGES OFF

SET ERROR MESSAGES OFF

SET ERROR MESSAGE 2495 OFF

CONNECT dbname IDENTIFIED BY ownername

SET ERROR MESSAGE 2495 ON

SET MESSAGES ON

SET ERROR MESSAGES ON

-- Check the availability of database

IF SQLCODE = -7 THEN

CLS

PAUSE 2 USING 'Unable to Connect the Database.' +

CAPTION ' Your Application Caption Here ...' +

ICON WARNING +

BUTTON 'Press any key to continue ...' +

OPTION BACK_COLOR WHITE +

|MESSAGE_FONT_NAME Tahoma +

|MESSAGE_FONT_COLOR RED +

|MESSAGE_FONT_SIZE 11

CLOSEWINDOW

EXIT

ENDIF

-- Enforce Database 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 DATE FORMAT MM/DD/YYYY

SET DATE SEQUENCE MMDDYY

SET DATE YEAR 30

SET DATE CENTURY 19

CLS

EDIT USING ApplicationMainMenu

RETURN

-- End here ...