R:BASE 7.5 for Windows Help
Keyword Index


R:BASE 7.5 Help
Introducing R:BASE 7.5
What's New in R:BASE 7.5
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.5
License Agreement
Copyrights
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
DialogBuilder.rbl
DialogWithButtonBuilder.rbl
GetFileExt.rbl
GetFileSize.rbl
GetTimeStamp.rbl
LoadDirectoryName.rbl
LoadFileName.rbl
LoadFileNamePlus.rbl
MapiMail.rbl
MapiMail2.rbl
MapiMail3.rbl
MapiMail4.rbl
Num2Word.rbl
PausePlug.rbl
RCalculator.rbl
RMeasurementConversion.rbl
RWhois.rbl
WCCountRBL.rbl
PREVROW
PREVTAB
PRINT
SCREEN
PRINTER
BMP
EMF
ETXT
GIF
HTML
JPG
PDF
RTF
TIFF
TXT
WMF
XHTML
XLS
EMAIL SET ON
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
RBADMIN
RECYCLE
REFRESH
REVERSE
ROWLOCKS
RULES
SCRATCH
SELMARGIN
SEMI
SEMI (Special Character)
SERVER
SINGLE
SORT
SORTMENU
STATICDB
TIME
TIMEOUT
TOLERANCE
TRACE
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
AND
ANSI
AUTOCOMMIT
AUTODROP
AUTOSKIP
BELL
BLANK
BUILD
CASE
CLEAR
CLIPBOARDTEXT
COLOR
COMPUTER
CONNECTIONS
CURRDIR
CURRDRV
CURRENCY
CURRENTPRINTER
DATABASE
DATE
DATE CENTURY
DATE FORMAT
DATE SEQUENCE
DATE YEAR
DBPATH
DEBUG
DELIMIT
DRIVES
ECHO
EDITOR
EOFCHAR
EQNULL
ERROR
ERROR DETAIL
ERROR VARIABLE
ESCAPE
EXPLODE
FASTFK
FASTLOCK
FEEDBACK
FILES
FIXED
HEADINGS
IDQUOTES
INSERT
INTENSITY
INTERVAL
LAST BLOCK TABLE
LAST ERROR
LAYOUT
LINES
LINEEND
LOOKUP
MANOPT
MANY
MAXTRANS
MDI
MESSAGES
MIRROR
MULTI
NAME
NETUSER
NOTE_PAD
NULL
OFFMESS
OLDLINE
ONELINE
PAGEMODE
PASSTHROUGH
PLATFORM
PLUS
POSFIXED
PORTS
PRINTERS
PRN_STATUS
PRN_ORIENTATION
PRN_SIZE
PRN_SOURCE
PRN_QUALITY
PRN_COPIES
PRN_COLORMODE
PRN_DUPLEXMODE
PRN_COLLATION
QUALCOLS
QUOTES
REFRESH
REVERSE
ROWLOCKS
RULES
SCRATCH
SCREENSIZE
SELMARGIN
SEMI
SERVER
SINGLE
SORT
SORTMENU
STATICDB
TIME
TIME FORMAT
TIME SEQUENCE
TIMEOUT
TOLERANCE
TRACE
TRANSACT
USER
USERDOMAIN
USERID
USERAPP
VERIFY
VERSION
VERSION BITS
VERSION BUILD
VERSION SYSTEM
WAIT
WALKMENU
WHILEOPT
WIDTH
WINBEEP
WINDOWSPRINTER
WRAP
WRITECHK
ZERO
ZOOMEDIT
D
DATETIME
DEXTRACT
DIM
DNW
DWE
DWRD
E
ENVVAL
EXP
F
FILENAME
FINDFILE
FLOAT
FORMAT
Aligning Decimals
Formatting Currency
Formatting Text
Punctuating Long Numbers
FV1
FV2
G
GETDATE
GETKEY
GETVAL
CheckMessageStatus
GetDriveReady
GetIPAddress
GetMACAddr
GetVolumeID
PlayAndExit
PlayAndWait
H
HTML
I
ICAP1
ICAP2
ICHAR
IDAY
IDIM
IDOY
IDWK
IFEQ
IFEXISTS
IFGT
IFLT
IFNULL
IFRC
IFWINDOW
IHASH
IHR
ILY
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
IWOY
IYR
IYR4
J
JDATE
L
LASTKEY
LAVG
LJS
LMAX
LMIN
LOG
LOG10
LTRIM
LUC
M
MOD
N
NEXT
NINT
P
PMT1
PMT2
PV1
PV2
R
RANDOM
RATE1
RATE2
RATE3
RDATE
RJS
ROUND
RTIME
RTRIM
S
SFIL
SGET
SIGN
SIN
SINH
SLEN
SLOC
SLOCP
SMOVE
SOUNDEX
SPUT
SQRT
SRPL
SSUB
STRIM
T
TAN
TANH
TDWK
TERM1
TERM2
TERM3
TEXTRACT
TMON
TRIM
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
Reserved Words
Obsolete Commands
Forms
Reports
Labels
Applications
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
Entry/Exit Procedures (EEPs)
EEP Example
EEP Restricted Commands
EEP Restrictions
EEP Specific Commands
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
Managing Scratch Files ($$$)
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
Understanding Temporary Tables and Views
Temporary Tables and Views
Using the New LIMIT Syntax
LIMIT Syntax
Using the New TOP n Qualifier
TOP n Syntax
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
Component ID
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
Component ID
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
Refresh List
Command Files
Browse
New
Run
Trace
Edit
Copy
Rename
Delete
Help
Find Files...
Refresh List
Databases
Connect
Disconnect
Browse
New
Design
Copy
Rename
Delete
Help
Refresh List
Forms
New
Run
Design
Copy
Rename
Delete
Convert
Help
Refresh List
Labels
New
Run
Design
Copy
Rename
Delete
Convert
Help
Refresh List
Reports
New
Run
Design
Copy
Rename
Delete
Convert
Help
Refresh List
Stored Procedures
New
Run
Design
Copy
Rename
Delete
Help
Refresh List
Tables
New
Open
Design
Copy
Rename
Delete
Help
Refresh List
Views
New
Open
Design
Copy
Rename
Delete
Help
Refresh List
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 Bars
Default Form Settings
Form
Text Objects
Edit Objects
Button Objects
ListBox/ComboBox Objects
Panel Objects
CheckBox/RadioButton Objects
Form Properties
Properties
Dynamic Caption
Table Relations
EEPs
Miscellaneous
Caption Buttons
Themes
Timer
Form Controls
Standard Controls
Arrow
Static Text
Properties
Border
Effects
Blinking
Miscellaneous
Push Button
Properties
Effects
EEPs
Enhanced Panel
Properties
Effects
Enhanced Group Box
Properties
Effects
Wallpaper
Properties
Custom Wallpaper
Properties
Database Controls
DB Grid
Properties
Options
Columns
General
Predefined Values
Expressions
EEPs
DB Navigator
Properties
Hints
DB Label
Properties
Border
Effects
Blinking
DB Edit
Properties
Effects
EEPs
Pop-up Menus
DB Memo
Properties
Effects
Scroll Bars
EEPs
DB Rich Edit
Properties
Effects
Scroll Bars
EEPs
DB Date/Time Picker
Properties
Effects
Colors
Format
EEPs
DB Calendar
Properties
Colors
DB Web Browser
Properties
DB E-Mail Label
Properties
E-Mail Settings
DB Image
Properties
EEPs
DB Check Box
Properties
Effects
EEPs
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
ListBox Items
Expression
EEPs
DB Tree View
Properties
Effects
Tables and Fields
DB Lookup ListView
Properties
Effects
Lookup Settings
Columns
EEPs
Scrolling Region
Properties
Variable Controls
Variable Label
Properties
Border
Effects
Blinking
Variable Edit
Properties
Effects
EEPs
Pop-up Menus
Variable Memo
Properties
Effects
Scroll Bars
EEPs
Variable Rich Text
Properties
Effects
Scroll Bars
EEPs
Variable Date/Time Picker
Properties
Effects
Colors
Format
EEPs
Variable Calendar
Properties
Colors
Variable Web Browser
Properties
Variable E-Mail Label
Properties
E-Mail Settings
Variable Image
Properties
EEPs
Variable Check Box
Properties
Effects
EEPs
Variable Radio Button
Properties
Effects
EEPs
Variable Radio Group
Properties
Radio Buttons
Effects
EEPs
Variable Lookup Combo Box
Properties
Effects
Lookup Settings
EEPs
Variable Lookup List Box
Properties
Effects
Lookup Settings
EEPs
Variable Spin Edit
Properties
Effects
Buttons
Variable User Defined Combo Box
Properties
Effects
Combo Box Items
Expression
EEPs
Variable User Defined List Box
Properties
Effects
List Box Items
Expression
EEPs
Variable Lookup ListView
Properties
Effects
Lookup Settings
Columns
EEPs
Additional Controls
Bit Button
Properties
Effects
EEPs
Speed Button
Properties
EEPs
Office Button
Properties
Effects
EEPs
Drop-Down Menu Button
Properties
Menu Items
Image
Properties
EEP
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
EEPs
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
EEPs
Separator
Properties
Arrow Line
Properties
Arrows
Status Bar
Properties
Add Status Bar Pane
Clock Status
Properties
Blinking
Clock Status
Key Status
Properties
Key Status
Simple Status
Properties
Blinking
Glyph Status
Properties
Blinking
Glyph Status
Marquee Status
Properties
Blinking
Marquee Status
Table State Status
Properties
Table State Status
DB Field Status
Properties
DB Field Status
PDF Viewer
Properties
Internet Controls
Web Browser
Properties
E-Mail Label
Properties
E-Mail Settings
File System Controls
Directory Tree
Properties
File List Box
Properties
Legacy Controls
Vertical Line
Properties
Horizontal Line
Properties
3D Box
Properties
Panel
Properties
Group Box
Properties
ActiveX Controls
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
Default Label Settings
General
Label Objects
Memo Objects
Line Objects
Bar Codes
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
Diagonal 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
Sub Report
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
Default Report Settings
General
Label Objects
Memo Objects
Line Objects
Bar Codes
Report E-Mail Settings
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
Diagonal 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
Sub Report
Technical Documents
Creating Address Line Compression
Creating Summary, Title or Cover Pages
Designing Columnar Reports
Designing CrossTab Reports
Printing Report as Text File
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 Sub Reports
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
What does R:Style do?
Why use R:Style?
Features
Version History
A Bit of Advice
Configuring R:Style
Indenting and Outdenting
Breaking Multi-Command Lines
Line Wrapping and Unwrapping
Casing of Keywords
Casing of Non-Keywords
Finding Future Keyword Problems
Expansion of Keywords
Preventing Alteration of Certain Words
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
Frequently Asked Questions
R:BASE Community
Sample Applications and Command Files
Syntax Builder for PROPERTY Command
Syntax Builder for GETPROPERTY Command
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