The following table contains a list of commands that are considered to be obsolete. Most of these commands have been made obsolete by their SQL Compliant equivalent, and there is no guarantee that these commands will be supported in future versions of R:BASE. Any code which relies on any of these commands should be considered dangerous as their use may have unintended and unpredictable results.
While most items have a direct replacement there are some items that are listed as having no direct replacement. However it may be possible to replace those commands with other commands that emulate that functionality. For more information on the "Replacement" commands, refer to the R:BASE Help "Command Index", or press [F1] from any location in R:BASE.
One suggestion for task this task is to use the R:BASE built-in "Find in Files" utility. To launch this command file utility, choose "Utilities" > "Find in Files" from the main Menu bar. This interface will allow you to search your command files for obsolete commands and other words, so you are not forced to manually search the individual files.
Obsolete Command |
Replacement |
Notes |
#FORM_COLUMNNAME |
RBTI_FORM_COLNAME |
See also RBTI System Variables |
#FORM_FORMNAME |
RBTI_FORM_FORMNAME |
See also RBTI System Variables |
#FORM_TABLENAME |
RBTI_FORM_TBLNAME |
See also RBTI System Variables |
AVE() |
LAVG |
|
BUILD KEY |
CREATE INDEX |
|
CHANGE |
UPDATE |
|
CHANGE COLUMN |
ALTER TABLE |
|
CLOSE |
DISCONNECT |
|
COLUMNS |
CREATE TABLE |
|
(CVAL('FORM_ALIAS') |
RBTI_FORM_ALIAS |
See also RBTI System Variables |
(CVAL('FORM_CAPTION') |
GETPROPERTY RBASE_FORM CAPTION vCaption |
|
(CVAL('FORM_DATA') |
RBTI_FORM_COLVALUE |
See also RBTI System Variables |
(CVAL('FORM_DATA_TYPE') |
RBTI_FORM_DATATYPE |
See also RBTI System Variables |
(CVAL('FORM_FIELD_NAME') |
RBTI_FORM_COLNAME |
See also RBTI System Variables |
(CVAL('FORM_NAME') |
RBTI_FORM_FORMNAME |
See also RBTI System Variables |
(CVAL('FORM_TABLE') |
RBTI_FORM_TABLENAME |
See also RBTI System Variables |
DEFINE |
CREATE SCHEMA |
|
DELETE KEY |
DROP INDEX |
|
DELETE FROM #n |
DELETE FROM TableName WHERE CURRENT OF CURSOR |
See also DECLARE CURSOR |
DISPLAY |
EDIT USING |
Used with Variable Forms. |
DRAW |
NONE |
Used with Variable Forms. No direct replacement. |
ECHO |
SET ECHO ON |
|
EDIT VAR ... |
NONE |
Used with Variable Forms. No direct replacement. |
ENTER VAR ... |
NONE |
Used with Variable Forms. No direct replacement. |
ESC |
[ESC] |
Used in IF and WHERE clauses to compare to the Esc key. |
Value1 EQ Value2 |
Value1 = Value2 |
Value1 equals Value2 |
EXISTS |
IS NOT NULL |
|
EXPAND |
ALTER TABLE |
|
EXPRESS |
RBAPP |
|
FAILS |
IS NULL |
|
FILLIN |
DIALOG |
In windows consider using DIALOG, ENTER or EDIT. |
Value1 GE Value2 |
Value1 >= Value2 |
Value1 greater than or equal to Value2. |
Value1 GT Value2 |
Value1 > Value2 |
Value1 greater than Value2. |
IN #n |
WHERE CURRENT OF CURSOR |
Used with UPDATE and SET VAR commands. |
Value1 LE Value2 |
Value1 <= Value2 |
Value1 less than or equal to Value2. |
Value1 LT Value2 |
Value1 < Value2 |
Value1 less than or equal to Value2. |
MAX() |
LMAX() |
|
MICRORIM_RETURN |
STP_RETURN |
|
MICRORIM_WALLPAPER |
NONE |
This variable was only used with Forms and Reports created for R:WEB. |
MIN() |
LMIN() |
|
Value1 NE Value2 |
Value1 <> Value2 |
Value1 does not equal Value2. |
NEXT |
FETCH |
See also DECLARE CURSOR |
NOECHO |
SET ECHO OFF |
|
OPEN |
CONNECT |
|
OWNER |
CREATE SCHEMA |
|
PASSWORDS |
GRANT |
|
PLAYBACK |
NONE |
No Replacement. |
POPUP/PULLDOWN Menus |
NONE |
Use #LIST option of CHOOSE command. Use LISTOF command option to create list of items. |
PROMPTS |
Now DOS Only. |
|
RECORD |
NONE |
|
REDEFINE |
ALTER TABLE |
|
REMOVE |
DROP |
|
RESET |
NONE |
No Replacement. |
#RETURN |
NONE |
Used with Variable Forms. No Direct Replacement. |
SCREEN RESTORE |
RECALC VARIABLES |
Now DOS Only. |
SELECT FROM #n |
SELECT FROM TableName |
See also DECLARE CURSOR WHERE CURRENT OF cursor |
SET CGA |
NONE |
No Replacement. |
SET EXTENDED |
NONE |
R:BASE always operates in Extended Mode now. |
SET INTENSITY |
NONE |
Use "Selected Row" color option in Scrolling Region Properties. |
SET OLDLINE |
NONE |
Use the Page Style option in Reports. |
SET POINTER |
DECLARE CURSOR |
|
SET RBGSIZE |
No replacement necessary due to imbedded form properties. Command is ignored. |
|
SET USERAPP |
NONE |
No replacement. |
SNAP |
NONE |
No replacement. |
SORTED BY |
ORDER BY |
|
USER |
CONNECT IDENTIFIED BY ... |
|
VIEW |
CREATE VIEW |
|
WRITE |
In Windows consider using DIALOG, PAUSE, ENTER or EDIT. |
|
ZIP RBEDIT |
RBEDIT |
RBEDIT is no longer a separate executable. |
ZIP RBSYNC |
RBSYNC |
RBSYNC is no longer a separate executable. |
