Obsolete Commands  
  
The following Table contains a list of commands that are considered to be obsolete. Most of these commands have been made obsolete by the SQL Compliant equivilant and there is no guarentee that these will be supported in future versions of R:BASE. Code which relys on any of these commands should be considered dangerous as their use may have unintended and unpredictable results.  
 
Where applicable, links have been included to the new command.  
 
One possible use for this table is to use the Microsoft Windows Find dialog to search your command files to see what needs to be fixed. Simply go to your Start Menu and click on Find. You can also use the "Windows Key-F" combination to pull up this dialog if your keyboard has a Windows Key (It looks like a small Windows logo). Depending on which version of windows you have this box may be formatted differently. In all cases though on one of the tabs there should be a "Find Files Containing Text" or similiarly worded option. If you put the following commands in this will pull up all files that contain that command.  
 
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 example Variable Forms are no longer supported but by creating a table with column names that match the variables in your variable form you can replicate the functionality of the form and then use a loop to take those records and process them as you did in your old routines.  
 
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.
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 EDITOR
NONE
No Replacement due to enhanced RBEDIT module.
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 7.x properties. Command is ignored.
SET USERAPP
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 seperate
executable.
ZIP RBSYNC
RBSYNC
RBSYNC is no longer a seperate
executable.