Schedule and Locations:

  • New locations to be announced...
Cost Per Attendee: $895.00

Training Style: Lecture (all attendees should bring their notebook computers)

Days: 2

Time: 9:00 AM - 5:00 PM

For reservations and/or questions, please call 1+724.733.0053 or send an email to rbasetraining@rbase.com

Who Should Attend?

R:BASE X/X Enterprise for Non-Programmers is intended for new and existing R:BASE users/developers who would like to get a better understanding of the R:BASE X/X Enterprise 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 X/X Enterprise.

Topics:

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

Understanding the R:BASE X/X Enterprise 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-Sizable R> 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 to R:BASE X/X Enterprise for Windows
    • Databases
    • Forms
    • Reports
    • Labels
    • Views
    • Command Files
    • EEPs
    • Applications
  • Do's and Don'ts