| R:BASE 7.1 Help |
 | Introducing R:BASE 7.1 |
| What's New in R:BASE 7.1 |
 | Application Designer |
| Data Browser/Editor |
| Database Explorer |
| Enhanced Commands |
| File Gateway |
| Forms and Form Designer |
| Labels and Label Designer |
| New Commands/Functions |
| Query Designer |
| R:BASE Editor |
| R> Prompt |
| Reports and Report Designer |
| Trace Debugger |
 | Installing R:BASE 7.1 |
 | License Agreement |
 | Complimentary Technical Support |
 | On Line Registration |
 | Product Updates |
| Command Index |
 | Reading Command Syntax |
| A |
| ABORT |
| ALTER TABLE |
| APPEND |
| ATTACH |
| AUTOCHK |
| AUTOFIX |
| AUTONUM |
| B |
| BACKUP |
| BEEP |
| BREAK |
| BROWSE |
| BROWSE USING |
| C |
| CALL |
| CASCADE |
| CHDIR |
| CHDRV |
| CHKDSK |
| CHOOSE |
| CLEAR |
| CLOSE |
| CLOSEWINDOW |
| CLS |
| CODELOCK |
| COMMENT |
| COMMENT ON |
| COMMIT |
| COMPUTE |
| CONNECT |
| CONTINUE |
| CONVERT |
| COPY |
| CREATE INDEX |
| CREATE SCHEMA |
| CREATE TABLE |
| CREATE VIEW |
| CROSSTAB |
| D |
| DEBUG |
| DECLARE CURSOR |
| DELETE |
| DELETE DUPLICATES |
| DELROW |
| DETACH |
| DIALOG |
| DIR |
| DISCONNECT |
| DISPLAY |
| DROP |
| DUPROW |
| E |
| EDIT |
| EDIT USING |
| ENTER |
| ERASE |
| EXIT |
| EXITFORM |
| F |
| FETCH |
| FILLIN |
| FLUSH |
| FORMS |
| G |
| GATEWAY |
| GET |
| GETPROPERTY |
| GOTO |
| GRANT |
| H |
| HELP |
| I |
| IF/ENDIF |
| INPUT |
| INSERT |
| INTERSECT |
| J |
| JOIN |
| L |
| LABEL |
| LAUNCH |
| LBLPRINT |
| LIST |
| LIST ACCESS |
| LOAD |
| M |
| MAXIMIZE |
| MINIMIZE |
| MKDIR |
| N |
| NEWPAGE |
| NEWROW |
| NEXTROW |
| NEXTTAB |
| NORMALIZE |
| O |
| ON CONNECT/PACK |
| ON ERROR |
| OPEN |
| ORDER BY |
| OUTPUT |
| P |
| PACK |
| PAUSE |
| PLUGINS |
| PREVROW |
| PREVTAB |
|
| PRNSETUP |
| PROJECT |
| PROPERTY |
| PUT |
| Q |
| QUERY |
| QUIT |
| R |
| RBAPP |
| RBBEDIT |
| RBDEFINE |
| RBEDIT |
| RBLABELS |
| RBSYNC |
| RECALC |
| RECORD |
| RECOVER |
| RELOAD |
| RENAME |
| REPORTS |
| RESETROW |
| RESTORE |
| RETURN |
| REVOKE |
| RHELP |
| RHIDE |
| RMDIR |
| ROLLBACK |
| RPHONE |
| RSHOW |
| RULES |
| RUN |
| S |
| SATTACH |
| SAVEROW |
| SCONNECT |
| SCREEN RESTORE |
| SDETACH |
| SDISCONNECT |
| SELECT |
| SELECT Functions |
| INTO |
| FROM |
| OUTER JOIN |
| WHERE |
| Sub-SELECT |
| AS |
| GROUP BY |
| HAVING |
| ORDER BY |
| UNION |
| HTML |
| SET |
| AND |
| ANSI |
| AUTOCOMMIT |
| AUTOCONVERT |
| AUTODROP |
| AUTORECOVER |
| AUTOROWVER |
| AUTOSKIP |
| AUTOSYNC |
| AUTOUPGRADE |
| BELL |
| BLANK |
| CAPTION |
| CASE |
| CLEAR |
| CLIPBOARD |
| COLOR |
| COMPATIB |
| CURRENCY |
| DATE |
| DEBUG |
| DELIMIT |
| ECHO |
| EOFCHAR |
| EQNULL |
| ERROR MESSAGE |
| ERROR MESSAGES |
| ERROR VARIABLE |
| ESCAPE |
| EXPLODE |
| FASTFK |
| FASTLOCK |
| FEEDBACK |
| FILES |
| FIXED |
| FONT |
| HEADINGS |
| IDQUOTES |
| INDEXONLY |
| INSERT |
| INTERVAL |
| KEYMAP |
| LAYOUT |
| LINEEND |
| LINES |
| LOCK |
| LOOKUP |
| MANOPT |
| MANY |
| MAXTRANS |
| MDI |
| MESSAGES |
| MIRROR |
| MOUSE |
| MULTI |
| NAME |
| NOTE_PAD |
| NULL |
| ONELINE |
| PAGEMODE |
| PASSTHROUGH |
| PLUS |
| POSFIXED |
| PRINTER |
| PROCEDURE |
| QUALCOLS |
| QUOTES |
| REFRESH |
| REVERSE |
| ROWLOCKS |
| RULES |
| SCRATCH |
| SELMARGIN |
| SEMI |
| SEMI (Special Character) |
| SERVER |
| SINGLE |
| SORT |
| SORTMENU |
| STATICDB |
| TIME |
| TIMEOUT |
| TOLERANCE |
| TRANSACT |
| USER |
| VERIFY |
| WAIT |
| WALKMENU |
| WHILEOPT |
| WIDTH |
| WINBEEP |
| WRAP |
| WRITECHK |
| ZERO |
| ZOOMEDIT |
| SET VARIABLE |
| SETFOCUS |
| SHOW |
| SHOW ERROR |
| SHOW VARIABLE |
| SKIP |
| SNAP |
| SSQL |
| SUBTRACT |
| SWITCH/ENDSW |
| T |
| TALLY |
| TILE |
| TRACE |
| TYPE |
| U |
| UNION |
| UNLOAD |
| UPDATE |
| UPGRADE |
| W |
| WHENEVER |
| WHERE |
| WHILE/ENDWHILE |
| WRITE |
| Z |
| ZIP |
| Function Index |
| Function Categories |
| A |
| ABS |
| ACOS |
| ADDDAY |
| ADDFRC |
| ADDHR |
| ADDMIN |
| ADDMON |
| ADDSEC |
| ADDYR |
| AINT |
| ANINT |
| ASIN |
| ATAN |
| ATAN2 |
| B |
| BRND |
| C |
| CHAR |
| CHKFILE |
| CHKKEY |
| COS |
| COSH |
| CTR |
| CTXT |
| CVAL |
| BUILD |
| CLIPBOARDTEXT |
| COMPUTER |
| CONNECTIONS |
| CURRDIR |
| CURRDRV |
| CURRENCY |
| CURRENTPRINTER |
| DATABASE |
| DATE |
| DATE CENTURY |
| DATE FORMAT |
| DATE SEQUENCE |
| DATE YEAR |
| DBPATH |
| DEBUG |
| DRIVES |
| ERROR DETAIL |
| ERROR VARIABLE |
| LAST ERROR |
| NETUSER |
| PLATFORM |
| PRINTERS |
| SCREENSIZE |
| USERDOMAIN |
| USERID |
| VERSION |
| VERSION BITS |
| VERSION BUILD |
| VERSION SYSTEM |
| WINDOWSPRINTER |
| D |
| DATETIME |
| DEXTRACT |
| DIM |
| DWRD |
| E |
| ENVVAL |
| EXP |
| F |
| FILENAME |
| FINDFILE |
| FLOAT |
| FORMAT |
| Aligning Decimals |
| Formatting Currency |
| Formatting Text |
| Punctuating Long Numbers |
| FV1 |
| FV2 |
| G |
| GETDATE |
| GETKEY |
| GETVAL |
| GetDriveReady |
| GetVolumeID |
| GetMACAddr |
| PlayAndExit |
| PlayAndWait |
| H |
| HTML |
| I |
| ICAP1 |
| ICAP2 |
| ICHAR |
| IDAY |
| IDWK |
| IFEQ |
| IFEXISTS |
| IFGT |
| IFLT |
| IFNULL |
| IFRC |
| IFWINDOW |
| IHASH |
| IHR |
| IMIN |
| IMON |
| INT |
| ISALPHA |
| ISDIGIT |
| ISEC |
| ISLOWER |
| ISSPACE |
| ISTAT |
| CURRNUMALLOC |
| CURSORCOL |
| CURSORROW |
| DBSIZE |
| DISKSPACE |
| FORM_CONTROL_TYPE |
| FORM_DIRTY_FLAG |
| ISRUNTIME |
| LIMITNUMALLOC |
| MAXFREE |
| MAXNUMALLOC |
| MEMORY |
| MOUSECOL |
| MOUSEROW |
| PAGECOL |
| PAGEROW |
| RB1SIZE |
| RB2SIZE |
| RB3SIZE |
| RB4SIZE |
| TOTALALLOC |
| TOTALFREE |
| TOTALLOCKS |
| TOTALREADS |
| TOTALWRITES |
| ISUPPER |
| ITEMCNT |
| IYR |
| IYR4 |
| J |
| JDATE |
| L |
| LASTKEY |
| LAVG |
| LJS |
| LMAX |
| LMIN |
| LOG |
| LOG10 |
| LUC |
| M |
| MOD |
| N |
| NEXT |
| NINT |
| P |
| PMT1 |
| PMT2 |
| PV1 |
| PV2 |
| R |
| RANDOM |
| RATE1 |
| RATE2 |
| RATE3 |
| RDATE |
| RJS |
| ROUND |
| RTIME |
| S |
| SFIL |
| SGET |
| SIGN |
| SIN |
| SINH |
| SLEN |
| SLOC |
| SMOVE |
| SOUNDEX |
| SPUT |
| SQRT |
| SRPL |
| SSUB |
| STRIM |
| T |
| TAN |
| TANH |
| TDWK |
| TERM1 |
| TERM2 |
| TERM3 |
| TEXTRACT |
| TMON |
| U |
| UDF (User-Defined Functions) |
| DOS and OS/2 UDF Differences |
| ERRORLEVEL |
| Limitations and Issues |
| Memory Issues |
| Returning Multiple Values |
| Sample UDF |
| ULC |
| W |
| WINUDF |
| Reference Index |
| Reference Topics |
| Binary Large Objects (BLOB) |
| BLOB Information |
| Constraints |
| Types of Constraints |
| Conversion Issues & Considerations |
| Converting Legacy Databases |
| Color Flow Chart |
| Obsolete Commands |
| Reserved Words |
| Forms |
| Reports |
| Labels |
| Displaying Fonts |
| How DOS and Windows Display Fonts |
| How R:BASE Displays Fonts |
| Problems When Displaying Data |
| Problems when Displaying Higher Order Characters |
| Dynamic Link Libraries (DLL) |
| Introduction to DLL's |
| Advanced DLL Information |
| Expressions |
| Purpose of an Expression |
| Expression Operators |
| Operators Used in Expressions |
| Rules for Defining Expressions |
| Expression Data Types |
| Data Type Results |
| Displaying the Calculated Values of Expressions |
| Examples of Expressions |
| Form EEP Information |
| EEP Example |
| EEP Restricted Commands |
| EEP Restrictions |
| EEP Specific Commands |
| EEP Specific Commands |
| Entry/Exit Procedures (EEPs) |
| Field Calculations |
| RECALC Command Options |
| Redisplaying Field Values |
| Screen Data Displays |
| Indexes |
| Purpose of Indexes |
| Multi-User Considerations |
| Single-User Mode |
| Multi-User Mode |
| R:BASE Access Limitations Table |
| Other Multi-User Considerations |
| Clearing Buffers with the SET CLEAR Command |
| Multi-User Locks Listed by LIST TABLE |
| Displaying Multi-User Locks |
| Using SET LOCK to Set Exclusive Table Locks |
| Using the SET VERIFY Command to Verify Data Entry |
| Using the SET ROWLOCKS Command to Lock Rows |
| Accessing Tables and Databases Table |
| Unavailable R:BASE Commands Table |
| Multi-User Concurrency Control and Locking Table |
| Introduction to Using R:BASE on a Network |
| Setting Up for Network Use |
| Sharing Network Resources |
| Setting the Multi-User Default |
| Concurrency Control |
| Resource Waiting |
| Schema Reading Mode with SET STATICDB |
| Types of Locks |
| Effects of the SET INTERVAL Command |
| Effects of the SET WAIT Command |
| RBTI System Variables Used in Forms |
| Rules |
| Purpose of a Rule |
| SQL |
| Information |
| Startup Files |
| Specifying a Startup File |
| Using Startup Files with Applications |
| Startup Parameters |
| Icon Settings |
| Stored Procedures & Triggers |
| Using Stored Procedures |
| Using Triggers |
| Transaction Processing |
| Transaction Processing |
| Using Transaction Processing |
| Locking Table Access and Resource Waiting |
| Row Locks and Transaction Processing |
| Automatic Table and Database Locks |
| Setting Exclusive Table Locks |
| Displaying Transaction Processing Locks |
| Resource Waiting in Transaction Processing |
| Recovering from Transaction Processing Errors |
| Using PAGEMODE |
| Overview of PAGEMODE |
| Example: Testing for the End of a Page |
| Example: Phone List with Breakpoints |
| Example: Multiple Breaks |
| Example: Employee Telephone List |
| Example: Checking Column Width |
| Example: Breakpoint Report |
| Example: Break Header/Footer |
| How To |
| Applications |
| Application Designer |
 | Application Designer File Logic and Behavior |
 | Getting Started |
| Selecting Database |
| Using the Application Designer |
| Part 1: Application Main Window |
 | Using Backgrounds |
| Part 2: Properties |
| Part 3: Images |
| Part 4: Actions |
| Caption Property |
| Hint Property |
| Action Name |
| Using Icons |
| Working With Actions |
| Part 5: Main Menu |
| Adding Root Level Items |
| Caption Property |
| Using Icons |
| Assigning Actions |
| Adding Sub-Items to the Selected Item |
| Menu Item Properties |
| Editing Items |
| Deleting Items |
| Part 6: Toolbar Drop-Down Menus |
| Creating New Drop-Down Menus |
| Adding Menu Items to a Drop-Down Menu |
| Deleting a Drop-Down Menu |
| Part 7: Toolbar |
| Layout and Options |
| Building a Toolbar |
| Rearranging Toolbar Components |
| Part 8: Testing Your Application |
| Part 9: Advanced Application Settings |
| Design-Time Password |
| Database and Path |
| User ID and Password |
| Application Wizard |
| Creating a New Application Using the Wizard |
| Part 1: Application Main Window |
| Caption Property |
| Loading and Clearing Icons |
| Using Backgrounds |
| Part 2: Images |
| Part 3: Actions |
| Caption Property |
| Hint Property |
| Action Name |
| Using Icons |
| Working With Actions |
| Part 4: Main Menu |
| Adding Root Level Items |
| Caption Property |
| Using Icons |
| Assigning Actions |
| Adding Sub-Items to the Selected Item |
| Menu Item Properties |
| Editing Items |
| Deleting Items |
| Part 5: Toolbar Drop-Down Menus |
| Creating New Drop-Down Menus |
| Adding Menu Items to a Drop-Down Menu (copy) |
| Deleting a Drop-Down Menu |
| Part 6: Toolbar |
| Layout and Options |
| Building a Toolbar |
| Part 7: Saving Your Application |
| Part 8: Testing Your Application |
 | Tips and Techniques |
| Codelock |
| Codelock |
| Converting an ASCII Command File to a Binary Command File |
| Add an ASCII Command File to a Procedure File |
| Add an ASCII Screen File to a Procedure File |
| Add an ASCII Menu File to a Procedure File |
| Convert an ASCII Application File to a Binary Procedure File |
| Data Browsing/Editing |
| Data Browser/Editor |
| Accessing the Data Browser/Editor |
 | Menu Bar |
| Toolbar |
| Navigation Bar |
| Viewing Modes |
| Viewing Data as a Grid |
| Viewing Data as a Row |
| Database Explorer |
| Database Explorer |
| Menu Bar |
| Toolbar |
| Property Bar |
| Group Bar |
| Applications |
| Browse |
| New |
| Run |
| Design |
| Copy |
| Rename |
| Delete |
| Help |
| Command Files |
| Browse |
| New |
| Run |
| Trace |
| Edit |
| Copy |
| Rename |
| Delete |
| Help |
| Databases |
| Connect |
| Disconnect |
| Browse |
| New |
| Design |
| Copy |
| Rename |
| Delete |
| Help |
| Forms |
| New |
| Run |
| Design |
| Copy |
| Rename |
| Delete |
| Convert |
| Help |
| Labels |
| New |
| Run |
| Design |
| Copy |
| Rename |
| Delete |
| Convert |
| Help |
| Reports |
| New |
| Run |
| Design |
| Copy |
| Rename |
| Delete |
| Convert |
| Help |
| Stored Procedures |
| New |
| Run |
| Design |
| Copy |
| Rename |
| Delete |
| Help |
| Tables |
| New |
| Open |
| Design |
| Copy |
| Rename |
| Delete |
| Help |
| Views |
| New |
| Open |
| Design |
| Copy |
| Rename |
| Delete |
| Help |
| File Gateway |
| File Gateway |
| Importing Data |
| Into Existing Table |
| Paradox |
| dBASE |
| Text |
| HTML |
| Excel |
| Lotus 1-2-3 |
| QuattroPro |
| XML |
| MS Access Database |
| Into New Table |
| Paradox |
| dBASE |
| Text |
| Settings |
| Setup |
| Comma Separated Values |
| Settings |
| Setup |
| Text Data |
| Settings |
| Setup |
| Text Printout |
| Settings |
| Setup |
| Tab Delimited |
| Settings |
| Setup |
| ASCII |
| Settings |
| Setup |
| HTML |
| MS Excel Spreadsheet |
| MS Excel Workbook |
| Lotus 1-2-3 (*.wk1) |
| Lotus 1-2-3 (*.wk2) |
| Lotus Symphony |
| QuattroPro |
| XML |
| MS Access Database |
| Exporting Data |
| Using the Export Wizard |
| Paradox |
| dBASE |
| Text |
| HTML |
| MS Excel Spreadsheet |
| MS Excel |
| MS Word |
| SYLK Symbolic Link |
| DIF Data Interchange Format |
| Lotus 1-2-3 |
| QuattroPro |
| SQL Script |
| XML |
| MS Windows Clipboard |
| Rich Text Format |
| SPSS Format |
| Adobe Acrobat Document |
| LDAP Data Interchange Format |
| Command Line Import/Export |
| Export |
| Import |
| Forms |
| Form Designer |
| Creating a New Form |
| Menu Bar |
| Tool Bar |
| Form Properties |
| Properties |
| Dynamic Caption |
| Table Relations |
| Miscellaneous |
| Form Controls |
| Standard Controls |
| Arrow |
| Static Text |
| Properties |
| Border |
| Effects |
| Blinking |
| Miscellaneous |
| Push Button |
| Properties |
| Effects |
| EEP's |
| Enhanced Panel |
| Properties |
| Effects |
| Enhanced Group Box |
| Properties |
| Effects |
| Wallpaper |
| Properties |
| Custom Wallpaper |
| Properties |
| Database Controls |
| Arrow |
| DB Grid |
| Properties |
| Columns |
| Properties |
| EEP's |
| DB Navigator |
| Properties |
| Hints |
| DB Label |
| Properties |
| Border |
| Effects |
| Blinking |
| DB Edit |
| Properties |
| Effects |
| EEP's |
| Pop-up Menus |
| DB Memo |
| Properties |
| Effects |
| Scroll Bars |
| EEP's |
| DB Rich Text |
| Properties |
| Effects |
| EEP's |
| DB Date/Time Picker |
| Properties |
| Effects |
| Colors |
| Format |
| DB Calendar |
| Properties |
| Colors |
| DB Web Browser |
| Properties |
| DB E-Mail Label |
| Properties |
| E-Mail Settings |
| DB Image |
| Properties |
| DB Check Box |
| Properties |
| Effects |
| EEP's |
| DB Radio Button |
| Properties |
| Effects |
| EEPs |
| DB Radio Group |
| Properties |
| Radio Buttons |
| Effects |
| EEPs |
| DB Lookup Combo Box |
| Properties |
| Effects |
| Lookup Settings |
| EEPs |
| DB Lookup List Box |
| Properties |
| Effects |
| Lookup Settings |
| EEPs |
| DB Spin Edit |
| Properties |
| Effects |
| Buttons |
| DB User Defined Combo Box |
| Properties |
| Effects |
| Combo Box Items |
| Expression |
| EEPs |
| DB User Defined List Box |
| Properties |
| Effects |
| List Box Items |
| Expression |
| EEPs |
| Scrolling Region |
| Properties |
| Variable Controls |
| Arrow |
| Variable Label |
| Properties |
| Border |
| Effects |
| Blinking |
| Variable Edit |
| Properties |
| Effects |
| EEP's |
| Pop-up Menus |
| Variable Memo |
| Properties |
| Effects |
| Scroll Bars |
| EEP's |
| Variable Rich Text |
| Properties |
| Effects |
| EEP's |
| Variable Date/Time Picker |
| Properties |
| Effects |
| Colors |
| Format |
| Variable Calendar |
| Properties |
| Colors |
| Variable Web Browser |
| Properties |
| Variable E-Mail Label |
| Properties |
| E-Mail Settings |
| Variable Image |
| Properties |
| Variable Check Box |
| Properties |
| Effects |
| EEP's |
| Variable Radio Button |
| Properties |
| Effects |
| EEP's |
| Variable Radio Group |
| Properties |
| Radio Buttons |
| Effects |
| EEP's |
| Variable Lookup Combo Box |
| Properties |
| Effects |
| Lookup Settings |
| EEP's |
| Variable Lookup List Box |
| Properties |
| Effects |
| Lookup Settings |
| EEP's |
| Variable Spin Edit |
| Properties |
| Effects |
| Buttons |
| Variable User Defined Combo Box |
| Properties |
| Effects |
| Combo Box Items |
| Expression |
| EEP's |
| Variable User Defined List Box |
| Properties |
| Effects |
| List Box Items |
| Expression |
| EEP's |
| Additional Controls |
| Arrow |
| Bit Button |
| Properties |
| Effects |
| EEP's |
| Speed Button |
| Properties |
| EEP's |
| Office Button |
| Properties |
| Effects |
| EEP's |
| Drop-Down Menu Button |
| Properties |
| Menu Items |
| Image |
| Properties |
| EEP's |
| Animated GIF Control |
| Properties |
| Shape |
| Properties |
| Bevel |
| Properties |
| AVI Animate |
| Properties |
| Splitter |
| Properties |
| Tab Control |
| Properties |
| Tab Page Properties |
| LED Text Label |
| Properties |
| Analog Clock |
| Properties |
| Digital Clock |
| Properties |
| Tree View |
| Properties |
| Effects |
| Images |
| Nodes |
| List View |
| Properties |
| Effects |
| Large Images |
| Small Images |
| Items |
| Shape Button |
| Properties |
| EEP's |
| Meter |
| Properties |
| Effects |
| Meter Settings |
| Segments |
| Group Bar |
| Properties |
| Border |
| Style |
| Enhanced Tab Control |
| Properties |
| Additional |
| Colors |
| Enhanced Tab Page Properties |
| Enhanced Speed Button |
| Properties |
| Effects |
| EEP's |
| Internet Controls |
| Arrow |
| Web Browser |
| Properties |
| E-Mail Label |
| Properties |
| E-Mail Settings |
| File System Controls |
| Arrow |
| Directory Tree |
| Properties |
| File List Box |
| Properties |
| Legacy Controls |
| Arrow |
| Vertical Line |
| Properties |
| Horizontal Line |
| Properties |
| 3D Box |
| Properties |
| Panel |
| Properties |
| Group Box |
| Properties |
| Anchors in Form Designer |
| RBTI System Variables Used in Forms |
| Technical Documents |
| Understanding the DB Grid EEP Options |
| Understanding the DB Navigator Object |
| Understanding the Splitter Object |
| Using Form System Variables |
| Using Format Mask in Form Designer |
| Using Panels and Splitters |
| More Up-to-Date Technical Documents |
| Labels |
| Label Designer |
| Creating a New Label |
| Menu Bar |
| Label Bands |
| Detail |
| Toolbars |
| Standard Controls |
| Variable Controls |
| Database Controls |
| Advanced Controls |
| Object Tree |
| Data Tree |
| Standard |
| Format |
| Edit |
| Draw |
| Align or Space |
| Size |
| Nudge |
| Label Controls |
| Standard Controls |
| Arrow |
| Label |
| Memo |
| Rich Text |
| Image |
| Shape |
| Line |
| Barcode |
| Checkbox |
| Rotated Label |
| Variable Controls |
| System Variable |
| Variable Label |
| Variable Memo |
| Variable Rich Text |
| Variable Image |
| Variable Barcode |
| Variable Check Box |
| Database Controls |
| DB Label |
| DB Memo |
| DB Rich Text |
| DB Calc |
| DB Image |
| DB Barcode |
| DB Check Box |
| Advanced Controls |
| Region |
| Crosstab |
| Technical Documents |
| Creating Address Line Compression |
| Designing Columnar Labels |
| Designing CrossTab Labels |
| Label Preview Options |
| Suppressing Repeated Values |
| Understanding Absolute Page Count and Page Number |
| Understanding Bar Codes |
| Understanding DBCalc Objects |
| Understanding Display Formats |
| Understanding Regions |
| Understanding The Pass Setting |
| Using System Variables |
| More Up-to-Date Technical Documents |
| Querys/Views |
| Query Builder |
| Menu Bar |
| Toolbar |
| Creating a New Query |
| Adding Tables |
| Removing Tables |
| Selecting Columns |
| Adding a WHERE Clause |
| Adding an ORDER BY Clause |
| Previewing Your Query |
| Saving Your Query |
| Save Query as View |
| Save Query as Temporary View |
| Viewing the SQL Statement |
| Query Wizard |
| Toolbar |
| Creating a New Query |
| Adding Tables |
| Removing Tables |
| Selecting Columns |
| Adding a WHERE Clause |
| Adding an ORDER BY Clause |
| Using Aggregate Functions |
| Grouping Columns |
| Previewing Your Query |
| Viewing the SQL Statement |
| R> Prompt |
| R> Prompt |
| Menu Bar |
| Toolbar |
| Settings |
| Command History |
| RBDefine |
| RBDefine |
| Creating a New Table |
| Menu Bar |
| Tabs |
| Table |
| Columns |
| Key/Indexes |
| Select Columns |
| New Key/Index |
| Primary Key |
| Unique Key |
| Index |
| Foreign Key |
| Rules |
| New Rule |
| Require a value |
| Require a unique value |
| Verify a value |
| Restrict deletion |
| Specify a maximum value |
| Specify a minimum value |
| Specify a value range |
| Custom Rule |
| Reports |
| Report Designer |
| Creating a New Report |
| Menu Bar |
| Report Bands |
| Report Header |
| Page Header |
| Break Header(s) |
| Detail |
| Break Footer(s) |
| Page Footer |
| Report Footer |
| Page Style |
| Toolbars |
| Standard Controls |
| Variable Controls |
| Database Controls |
| Advanced Controls |
| Object Tree |
| Data Tree |
| Standard |
| Format |
| Edit |
| Draw |
| Align or Space |
| Size |
| Nudge |
| Report Controls |
| Standard Controls |
| Arrow |
| Label |
| Memo |
| Rich Text |
| Image |
| Shape |
| Line |
| Barcode |
| Checkbox |
| Rotated Label |
| Variable Controls |
| System Variable |
| Variable Label |
| Variable Memo |
| Variable Rich Text |
| Variable Image |
| Variable Barcode |
| Variable Check Box |
| Database Controls |
| DB Label |
| DB Memo |
| DB Rich Text |
| DB Calc |
| DB Image |
| DB Barcode |
| DB Check Box |
| Advanced Controls |
| Region |
| Crosstab |
| Technical Documents |
| Creating Address Line Compression |
| Creating Summary, Title or Cover Pages |
| Designing Columnar Reports |
| Designing CrossTab Reports |
| Report Preview Options |
| Suppressing Repeated Values |
| Understanding Absolute Page Count and Page Number |
| Understanding Bar Codes |
| Understanding DBCalc Objects |
| Understanding Display Formats |
| Understanding Regions |
| Understanding The New Page and New Page Threshold |
| Understanding the Page Style Band |
| Understanding The Pass Setting |
| Using Breakpoints |
| Using System Variables |
| More Up-to-Date Technical Documents |
| R:BASE Editor |
| R:BASE Editor |
| Menu Bar |
| Toolbar |
| File Structure Panel |
| Editor Window |
| Hot Keys |
| Editor Settings |
| General |
| String |
| Display |
| Color |
| R:Style |
| Introduction |
| Installing R:Style |
| What does R:Style do? |
| Why use R:Style? |
| Features |
| Version History |
| A Bit of Advice |
| Configuring and Running R:Style |
| Configuring R:Style |
| Indenting and Outdenting |
| Breaking Multi-Command Lines |
| Line Wrapping and Unwrapping |
| Casing of Keywords |
| Finding Future Keyword Problems |
| Expansion of Keywords |
| Preventing Alteration of Certain Words |
| Casing of Non-Keywords |
| Customizing Mixed Case Table or Column Names |
| Customizing Mixed Case Variable Name |
| Simplifying Maintenance |
| Customized Word Expansions/Substitution |
| Order of Processing |
| Running R:Style |
| Troubleshooting |
| Trace Debugger |
| Trace Debugger |
| Overview |
| Using the Trace Debugger |
| Breakpoints |
| Setting Breakpoints |
 | Clearing Breakpoints |
| Watch Variables |
| Adding/Removing Watch Variables |
| Modifying Watch Variable Values |
 | Clearing Watch Variables |
| Saving Watch Variables |
 | Loading Watch Variables |
| Menu Bar |
| Tool Bar |
| Technical Documents |
| Changing Variable Values |
| Debugging CodeLocked Files and Blocks |
| Debugging EEP's |
| Debugging Nested RUN Commands |
| Online References |
| Up-to-Date Technical Documents |
| R:BASE Community |
| Sample Applications and Command Files |
| Syntax Builder for PROPERTY Command |
| Syntax Builder for GETPROPERTY Command |
 | Preview of Sample Applications |
| Legacy Technical Documents |
 | Newsroup (Email List) |
| Data Types |
| Hot Keys |
| PAUSE Icons |
| Tutorial |
| Introduction |
| Lesson 1 - Database Design |
| Introducing SkyWrite Ink |
| About this Lesson |
| Database Design? |
| Good Database Design |
| Final Design |
| Summary |
| Lesson 2 - Defining a Database |
| Creating a Database |
| Defining Primary and Foreign Keys |
| Defining Indexes |
| The Database Files |
| Importing Data into the Database |
| Changing Database Structure |
| Summary |
| Lesson 3 - Viewing Data |
| Displaying Data |
| Hiding Columns |
| Redisplaying Hidden Columns |
| Changing the Column Size |
| Moving Columns |
| Locking Columns |
| Clearing Locked Columns |
| Working with Data |
| Adding a Row |
| Deleting a Row |
| Sorting Data by a Single Column |
| Sorting Data by Multiple Columns |
| Performing Calculations on Table Data |
| Note/BLOB Field Viewer/Editor |
| The Query Wizard |
| Analyzing Data with Queries |
| Selecting Columns for a Query |
| Specifying a Condition for a Query |
| Modifying the Condition for a Query |
| Printing the Query Results |
| Creating Views |
| The View Designer |
| Selecting Tables for a View |
| Linking Tables |
| Selecting Columns for a View |
| Looking at the Query Results |
| Saving the Query |
| Summary |
| Lesson 4 - Creating and Modifying Forms |
| Designing a Form |
| The Form Designer |
| Creating a Quick Form with the Form Wizard |
| Understanding the Form Designer Interface |
| Customizing the Form Designer Environment |
| Field Object Properties |
| Customizing the Form |
| Editing Text Objects |
| Changing the Size of Objects |
| Moving Objects |
| Aligning Objects |
| Entering and Editing Text Objects |
| Creating a Bevel |
| Placing an Analog Clock |
| Additional Objects |
| Form Properties |
| Saving and Closing Forms |
| Testing the Form |
| Running the Form |
| Creating a Custom Form |
| Using Expressions and Variables |
| Placing Objects |
| Placing Text Objects |
| Placing DB Edit (column) Objects |
| Placing Variable Objects |
| Placing DB Memo (scrolling) Objects |
| Placing a DB Lookup Combo Box |
| DB User Defined Combo Box |
| Defining a Pop-Up Menu |
| Completing the Form |
| Form Hints |
| Changing Object Properties |
| Changing the Tab Order |
| Running the Custom Form |
| Summary |
| Lesson 5 - Creating and Modifying Reports |
| Defining a Report |
| Creating an Employee Phone List |
| Building the Employee Phone List with the Report Wizard |
| The Report Designer |
| Modifying the Employee Phone List Report |
| Editing the Page Title |
| Changing the Column Headings |
| Resizing Objects |
| Report System Variables |
| Final Result |
| Previewing the Employee Phone List |
| Printing the Employee Phone List |
| Launching Files |
| Creating a Scheduled Flights List |
| Designing the Scheduled Flights Report |
| Building the Scheduled Flights Report |
| Report Sections |
| Removing Report Sections |
| Adding a Report Title |
| Changing the Size of the Detail Section |
| Placing Label (text) Objects |
| Aligning the Label Objects |
| Spacing the Label Objects |
| Placing DB Text (column) Objects |
| Placing a DB Memo (column) Object |
| Resizing and Aligning Column Objects |
| Saving and Previewing the Scheduled Flights Report |
| Modifying the Scheduled Flights Report |
| Adding a Format for Null Values |
| Adding a Breakpoint |
| Placing Objects in the Break Header |
| Adding a Display Format |
| Choosing DB Calc over using a computed variable in reports |
| Adding a Daily Total object using DB Calc |
| Placing Objects in the Report Footer Section |
| Adding a Grand Total DB Calc object |
| Changing Printing Styles |
| Finishing the Report |
| Saving and Closing the Report |
| Printing the Scheduled Flights Report |
| Summary |
| Tips |
| Lesson 6 - Creating and Modifying Labels |
| Building a Label |
| Designing a Mailing Label |
| Building a Label for a Customer Mailing List |
| Defining Variables for the Label |
| Placing Objects on the Label |
| Placing the Remaining Objects |
| Previewing the Label |
| Saving and Closing the Label |
 | Line Compression |
| Summary |
| Lesson 7 - Creating and Using an Application |
| Designing an Application |
| Identifying the Tasks Skyapp Will Perform |
| Organizing the Tasks Into Menus |
| Building an Application |
| Creating Menu Actions to Enter Data |
| Creating Menu Actions to Edit Data |
| Creating Menu Actions to Print Data |
| Assigning Actions to the Flights and Exit Menus |
| Defining the Main Menu |
| Defining the Employees Main Menus |
| Defining the Flights and Exit Menus |
| Final Steps |
| The Application Designer Environment |
| Testing an Application |
| Testing the Employees Menu |
| Testing the Customers Menu |
| Testing the Flights Menu |
| Exiting the Application |
| Modifying an Application |
| Running an Application |
| Summary |
| Lesson 8 - Maintaining a Database |
| Backups |
| What to Back Up |
| Checking the Database |
| Copying Database Files |
| Understanding R:BASE BACKUP and RESTORE |
| Backing Up Database Structure |
| Backing Up Database Data |
| Backing Up a Database |
| Confirming the Backup File was Created |
| Restoring a Database |
| Using the Restore command |
| The UNLOAD Command |
| Compressing the Database |
| Pack In Place Versus Reload |
| Using the Pack In Place Option |
| Using the Reload Option |
| Summary |
| Glossary |
| A |
| B |
| C |
| D |
| E |
| F |
| I |
| K |
| L |
| M |
| N |
| O |
| P |
| Q |
| R |
| S |
| T |
| V |
| Technical Support |
| Feedback |
| Frequently Asked Questions |