Who Should Attend?

R:BASE for Non-Programmers is intended for new and existing R:BASE users/developers who would like to get a better understanding of the for Windows Designers, command syntax, custom environment settings, and basic tips and tricks. This course is for those who are already comfortable in R:BASE and wish to evolve into understanding the many facets of R:BASE.

Topics:

Introduction

• Installation and Configuration
• Default Directories
• Default Settings
• Customizing Personal Settings
• Understanding the Configuration File

Understanding the R:BASE for Windows Environment

Understanding the Menu Bar

• Database
• Tools
• Settings
• Utilities
• Window
• Help

Understanding the Tool Bar

• R:BASE Database Explorer
• R:BASE Editor
• R> Prompt
• Browse/Edit Table
• Query Builder
• RBDefine
• Application Designer
• Codelock
• File Gateway
• Report Designer
• Label Designer
• Form Designer
• Print Report/Label
• Run a Form
• Help

Understanding the Group Bar

• Databases
• Applications
• Command Files
• Tables
• Views
• Stored Procedures
• Reports
• Labels
• Forms

Using the R:BASE and SQL Command Syntax

• Reading Command Syntax
• New and Enhanced Commands
• PROPERTY
• GETPROPERTY
• PRINT
• GATEWAY
• CHOOSE
• DIALOG
• PAUSE
• Understanding Plugins
• Customizing CHOOSE, PAUSE, and DIALOG commands
• Creating Command Files
• Using Entry/Exit Procedures
• Using R:BASE Functions

R:BASE Editor (RBEdit)

• Editor Settings
• General
• String
• Display
• Color
• Command File Analyzer (Structure)
• Bookmarks
• Watch Variables
• Data Dictionary
• Command Dictionary
• Copy, Cut, Paste, Search, Replace
• R:Style (Ctrl+Y)
• -ERROR- Messages
• Exporting your command file to RTF and HTML Files

R> Prompt

• Re-SizableR> Prompt Window
• Context Sensitive Syntax Help
• Context Sensitive Command Paste
• Result Window
• Copying and Pasting Results
• Command History
• Customizing R> Prompt Settings
• Data Dictionary
• Saving and Managing Output Results
• Running Command Files
• Using Watch Variables

Understanding the Data Browser/Editor

• Switching Modes
• Search
• Moving Column(s)
• Show Column(s)
• Hiding Column(s)
• Refresh
• Lock Columns
• Change Column Font
• Change Column Background Color
• Sorting Data
• Clear Sort
• Zebra Stripes
• Record Counter
• Switching to Single Row mode
• Displaying/Updating NOTE/VARCHAR/BLOB Data

Understanding the Query Builder

• Creating New Queries
• Modifying Existing Queries
• SQL Window
• Add Table(s)
• Remove Table(s)
• Selecting Column(s)
• Removing Column(s)
• Build SELECT Clause
• Build WHERE Clause
• Build ORDER BY Clause
• View Results in Query Browser
• Creating JOINs
• Creating UNIONs

Understanding the Data Designer (RBDefine)

• Data Wizard
• Creating New Database
• Adding Table(s)
• Adding Column(s)
• Adding Constraints
• Modifying Existing Table(s)
• Removing Column(s)
• Removing Constraints
• Defining Rules
• Enabling Triggers

Understanding the Application Designer

• Application Wizard
• Creating Applications
• Application Main Window
• Caption
• Icons
• Background
• Wallpaper
• Images
• Actions
• Main Menu
• Toolbar Drop-Down Menus
• Toolbar
• Designing Cool Applications

Understanding the Report Designer

• Tool Bar
• Standard Controls
• Variable Controls
• Database Controls
• Advanced Controls
  
  • Region
  • CrossTab
  • Sub-Report
  • PCC Label
• Object Tree
• Data Tree
• Standard
• Format
• Edit
• Draw
• Align or Space
• Size
• Nudge
• Rulers
• Grid Options
• Displaying Data
• Data Dictionary
• Report Header
• Report Footer
• Page Header
• Page Footer
• Page Style
• Breaks
  
  • Break On:
  • Data Field, Custom Field, Variable
  • On Break Change
  • Start New Page
  • Reset Page Number
  • New Page When Less Than ##
  • Keep Break Together
  • Reprint Break Header on Subsequent Pages
• Orientation (Portrait, Landscape)
• Cache Pages
• Pass Setting (One Pass, Two Pass)
• Units (Screen Pixels, Printer Pixels, Inches, Millimeters, Thousandths of MM)
• Variables
  
  • Add or Edit Variables
  • List Expressions
• Report Preview
  
  • Whole Page
  • Page Width
  • 100%
  • User Defined %
  • Goto First Page
  • Prior Page
  • Next Page
  • Last Page
  • Goto xx Page
• Print To
  
  • Printer
  • TXT File
  • HTML File
  • RTF File
  • PDF File
  • MS Excel File
  • JPEG File
  • GIF File
  • BMP File
  • EMF File
  • WMF File
  • File (Comma Delimited, Tab Delimited, Fixed Length)
  • DIF File
  • PNG File
  • SVG File
  • SYLK File
  • WB1 File
  • WK1 File
• Using System Variables
  
  • Date
  • Date Time
  • Document Name
  • Print Date Time
  • Page Count
  • Page Set
  • Page Set Desc
  • Page No
  • Page No Desc
  • Time
• Designing Sub Reports
• Designing Reports with Title/Summary Pages
• Designing CrossTab Reports
• Designing Columnar Reports
• Designing Reports with Watermarks
• Designing Reports with Regions

Understanding the Label Designer

• Label Templates
• Tool Bar
• Standard Components
• Data Components
• Advanced Components
• Variables/Expressions
• Object Tree
• Data Tree
• Format
• Ruler
• Grids
• Displaying Data
• Data Dictionary
• Cache Pages
• Pass Setting (One Pass, Two Pass)
• Units (Screen Pixels, Printer Pixels, Inches,Millimeters, Thousandths of MM)
• Label Preview
• Print To
  
  • TXT File
  • HTML File
  • RTF File
  • PDF File
  • MS Excel File
  • JPEG File
  • GIF File
  • BMP File
  • EMF File
  • WMF File
  • DIF File
  • PNG File
  • SVG File
  • SYLK File
  • WB1 File
  • WK1 File
• Designing Custom Mailing Labels
• Designing Security Tags
• Designing Employee Identity Cards
• Designing Product Labels with Barcodes

Understanding the Form Designer

• Menu Bar
• Tool Bar
• Wallpapers
• Backgrounds
• Standard Controls
• Database Controls
• Variable Controls
• Additional Controls
• Internet Controls
• File System Controls
• Legacy Controls
• Form Properties
• Object Properties
• Table Settings
• Variables/Expressions
• Object List/Analyzer
• Change Tab Order
• Data Dictionary
• Lock Control(s)
• Custom Themes

Miscellaneous Topics

• Upgrading R:BASE
  
  • Databases
  • Forms
  • Reports
  • Labels
  • Views
  • Command Files
  • EEPs
  • Applications
• Do's and Don'ts