image4

The Table tab allows you to specify properites such as the Table Name and Table Decription. You also have the option to edit an existing table by clicking the Open Existing Table button, or create a new table by clicking the New Table button.

You must enter a Table Name before you can access any of the other tab areas in the RBDefine module.


Fields


ð Table Name
 
A unique 1-18 character alpha-numeric name for the table.  
 
NOTE: Valid names must start with an alpha character and can include the following symbols: Letters (A-Z); Numbers (0-9); # (pound sign); _ (underscore); $ (dollar sign); % (percent sign). Spaces are NOT permitted. Also, for ODBC compliance, it is not recommended to use the # (pound sign) symbol in a table name even though R:BASE permits it.  
 
 
ð Table Description
 
An informational description for the table. This data is stored in a NOTE field, and therefore would follow the same restrictions as a NOTE data field.  
 

Additional Options


ð Temporary Table
 
Saves the current table definition as a temporary table.  
 

ð Cascade

Maintains primary/foreign key relationships automatically. A CASCADE can applied to UPDATE, DELETE or BOTH to specific primary keys. For example, if you either UPDATE or DELETE a primary key value from a table, the corresponding foreign key values are updated or deleted automatically. CASCADE can only be added to tables with primary keys.  
 
Separate UPDATE and DELETE data restrictions can allow a CASCADE to be enforced for values that are updated, but not enforced when records are deleted, in order to avoid an accidental or undesired record delete.  
 
Update - Enforces that when a primary key value is updated, the corresponding value in the foreign key table(s) will also be updated.  
 
Delete - Enforces that when a primary key value is deleted, the corresponding value in the foreign key table(s) will also be deleted.  


Buttons


ð New Table
 
This button allows you to create a new table.  
 

ð Open Existing Table
 
Allows you to choose a table from the list of currently defined tables to edit.  
 

ð Save

Commits any chages made since the last save.  


ð Save and Close

Commits any chages made since the last save and closes the RBDefine module.  


ð Close

Closes the RBDefine module. If unsaved changes have been made, you will be prompted to save them before closing.