R:BASE 7.6 Beginners Tutorial
203 Pages
English

R:BASE 7.6 Beginners Tutorial

-

Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

Description

7.6
Beginners Tutorial
The End-User's Guide to Building
R:BASE Databases and Custom Applications
R:BASE Technologies, Inc. R:BASE 7.6
Beginners Tutorial
by R:BASE Technologies, Inc.
Welcome to R:BASE 7.6 for Windows
Welcome to the Next Generation R:BASE 7.6 for Windows. R:BASE
is an Industrial-Strength, True 32-Bit, Multi-User Relational
Database. But R:BASE is not just a Database Management System;
it is a total GUI development environment for all Windows desktop
and network applications. R:BASE 7.6 for Windows is the ideal
Database Management Suite for creating and maintaining your
mission critical data with a true graphical user interface. Since its
introduction in 1981 as the first PC-based database management
system based on Dr. Codd’s relational model, R:BASE has led as
the first 32-bit DBMS in its class, providing programming-free
application development, automatic multi-user capabilities, 4GL (a
full-featured programming language in the R:BASE base product)
and embedded ANSI SQL. And now with R:BASE 7.6 for Windows,
we have added a whole new look and feel to enhance the
applications you develop in R:BASE. You can rapidly produce the
type of results that previously would have required various third
party development tools. Simply using native controls, you can now
design cool applications at a fraction of the cost and development
time when compared to other database and development tools
available.results that previously would have required various third
party ...

Subjects

Informations

Published by
Reads 79
Language English
Document size 5 MB
7.6 Beginners Tutorial The End-User's Guide to Building R:BASE Databases and Custom Applications R:BASE Technologies, Inc. R:BASE 7.6 Beginners Tutorial by R:BASE Technologies, Inc. Welcome to R:BASE 7.6 for Windows Welcome to the Next Generation R:BASE 7.6 for Windows. R:BASE is an Industrial-Strength, True 32-Bit, Multi-User Relational Database. But R:BASE is not just a Database Management System; it is a total GUI development environment for all Windows desktop and network applications. R:BASE 7.6 for Windows is the ideal Database Management Suite for creating and maintaining your mission critical data with a true graphical user interface. Since its introduction in 1981 as the first PC-based database management system based on Dr. Codd’s relational model, R:BASE has led as the first 32-bit DBMS in its class, providing programming-free application development, automatic multi-user capabilities, 4GL (a full-featured programming language in the R:BASE base product) and embedded ANSI SQL. And now with R:BASE 7.6 for Windows, we have added a whole new look and feel to enhance the applications you develop in R:BASE. You can rapidly produce the type of results that previously would have required various third party development tools. Simply using native controls, you can now design cool applications at a fraction of the cost and development time when compared to other database and development tools available.results that previously would have required various third party development tools. R:BASE 7.6 Beginners Tutorial Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. Information in this document, including URL and other Internet web site references, is subject to change without notice. The example companies, individuals, products, organizations and events depicted herein are completely fictitious. Any similarity to a company, individual, product, organization or event is completely unintentional. R:BASE Technologies, Inc. shall not be liable for errors contained herein or for incidental consequential damages in connection with the furnishing, performance, or use of this material. This document contains proprietary information, which is protected by copyright. Complying with all applicable copyright laws is the responsibility of the user. Without limiting the rights under copyright, no part of this document may be reproduced, stored in or introduced into a retrieval system, or transmitted in any form or by any means (electronic, mechanical, photocopying, recording, or otherwise), or for any purpose, without the express written consent of R:BASE Technologies, Inc. We reserve the right to make changes from time to time in the contents hereof without obligation to notify any person of such revision or changes. We also reserve the right to change the specification without notice and may therefore not coincide with the contents of this document. The manufacturer assumes no responsibilities with regard to the performance or use of third party products. Products that are referred to in this document may be either trademarks and/or registered trademarks of the respective owners. The publisher and the author make no claim to these trademarks. The software described in this document is furnished under a license agreement. The software may be used or copied only in accordance with the terms of that agreement. Any unauthorized use or duplication of the software is forbidden. R:BASE Technologies, Inc. may have patents, patent applications, trademarks, copyrights, or other intellectual property rights covering subject matter in this document. Except as expressly provided in any written license agreement from R:BASE Technologies, Inc., the furnishing of this document does not give you any license to these patents, trademarks, copyrights, or other intellectual property. Trademarks R:BASE®, OTERRO®, R:BASE C/S:I®, RBAdmin®, R:Scope®, R:WEB Suite®, R:CAD Viewer®, R:Twain2PDF®, R:PDF417®, R:Tango®, R:Spell Checker®, R:Biometric®, R:Accounting®, R:Capture®, R:Charts®, R:Docs®, R:Code®, R:QBDataDirect®, R:Contact®, R:BASE Editor®, R:BASE Plugin Power Pack®, R:Style®, R:Struc®, R:Java®, R:Mail®, R:QBSynchronizer®, R:QBDBExtractor®, R:Mail Editor®, R:Linux®, R:Archive®, R:Chat®, RDCC Client®, R:Mail Editor®, R:Code®, R:ColumnAnalyzer®, R:PDFMerge®, R:PDFSearch®, R:PDFWorks®, R:RemoteControl®, R:Synchronizer®, R:SureShip®, RBZip®, R:JobTrack®, R:TimeTrack®, R:Syntax®, R:WatchDog®, R:Merge®, R:Fax®, R:Documenter®, R:Magellan®, R:Manufacturing®, R:WEB Reports®, R:WEB Gateway®, R:ReadyRoute®, R:SFTPClient®, R:FTPClient®, R:Scheduler®, R:DWF Viewer®, R:PHP® and Pocket R:BASE® are trademarks or registered trademarks of R:BASE Technologies, Inc. All Rights Reserved. All other brand, product names, company names and logos are trademarks or registered trademarks of their respective companies. MS Windows, MS Windows 2008, 2003, 2000, NT, XP, and Vista are registered trademarks of Microsoft Corporation. Printed: January 2011 in Murrysville, PA Second Edition Special thanks to: All the people who contributed to the production of this document. I R:BASE 7.6 Beginners Tutorial Table of Contents 8Part I Introduction 17Part II Lesson 1 - Database Design 1 Introducing SkyWrite Ink ................................................................................................................................... 17 2 About this Lesson ................................................................................................................................... 17 3 Database Design? ................................................................................................................................... 18 4 Good Database Design ................................................................................................................................... 18 5 Final Design ................................................................................................................................... 24 6 Summary ................................................................................................................................... 25 27Part III Lesson 2 - Defining a Database 1 Creating a Database ................................................................................................................................... 27 2 Defining Primary and Foreign Keys ................................................................................................................................... 32 3 Defining Indexes ................................................................................................................................... 35 4 The Database Files ................................................................................................................................... 36 5 Importing Data into the Database ................................................................................................................................... 38 6 Changing Database Structure ................................................................................................................................... 38 7 Summary ................................................................................................................................... 42 45Part IV Lesson 3 - Viewing Data 1 Displaying Data ................................................................................................................................... 45 2 Hiding Columns ................................................................................................................................... 46 3 Redisplaying Hidden Columns ................................................................................................................................... 47 4 Changing the Column Size ................................................................................................................................... 47 5 Moving Columns ................................................................................................................................... 48 6 Locking Columns ................................................................................................................................... 48 7 Clearing Locked Columns ................................................................................................................................... 48 8 Working with Data ................................................................................................................................... 49 9 Adding a Row ................................................................................................................................... 49 10 Deleting a Row ................................................................................................................................... 49 11 Sorting Data by a Single Column ................................................................................................................................... 50 12 Sorting Data by Multiple Columns ................................................................................................................................... 50 13 Performing Calculations on Table Data ................................................................................................................................... 51 14 Note/BLOB Field Viewer/Editor ................................................................................................................................... 51 15 The Query Wizard ................................................................................................................................... 52 16 Analyzing Data with Queries ................................................................................................................................... 57 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. Contents II 17 Selecting Columns for a Query ................................................................................................................................... 58 18 Specifying a Condition for a Query ................................................................................................................................... 59 19 Modifying the Condition for a Query ................................................................................................................................... 62 20 Printing the Query Results ................................................................................................................................... 63 21 Creating Views ................................................................................................................................... 63 22 The View Designer ................................................................................................................................... 64 23 Selecting Tables for a View ................................................................................................................................... 65 24 Linking Tables ................................................................................................................................... 65 25 Selecting Columns for a View ................................................................................................................................... 66 26 Looking at the Query Results ................................................................................................................................... 67 27 Saving the Query ................................................................................................................................... 68 28 Summary ................................................................................................................................... 69 72Part V Lesson 4 - Creating and Modifying Forms 1 Designing a Form ................................................................................................................................... 72 2 The Form Designer ................................................................................................................................... 72 3 Creating a Quick Form with the Form Wizard ................................................................................................................................... 72 4 Understanding the Form Designer Interface ................................................................................................................................... 74 5 Customizing the Form Designer Environment ................................................................................................................................... 74 6 Field Object Properties ................................................................................................................................... 75 7 Customizing the Form ................................................................................................................................... 76 8 Editing Text Objects ................................................................................................................................... 77 9 Changing the Size of Objects ................................................................................................................................... 79 10 Moving Objects ................................................................................................................................... 80 11 Aligning Objects ................................................................................................................................... 81 12 Entering and Editing Text Objects ................................................................................................................................... 82 13 Creating a Bevel ................................................................................................................................... 83 14 Placing an Analog Clock ................................................................................................................................... 84 15 Additional Objects ................................................................................................................................... 84 16 Form Properties ................................................................................................................................... 84 17 Saving and Closing Forms ................................................................................................................................... 84 18 Testing the Form ................................................................................................................................... 85 19 Running the Form ................................................................................................................................... 85 20 Creating a Custom Form ................................................................................................................................... 85 21 Using Expressions and Variables ................................................................................................................................... 87 22 Placing Objects ................................................................................................................................... 88 23 Placing Text Objects ................................................................................................................................... 89 24 Placing DB Edit (column) Objects ................................................................................................................................... 89 25 Placing Variable Objects ................................................................................................................................... 90 26 Placing DB Memo (scrolling) Objects ................................................................................................................................... 91 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. II III R:BASE 7.6 Beginners Tutorial 27 Placing a DB Lookup Combo Box ................................................................................................................................... 92 28 DB User Defined Combo Box ................................................................................................................................... 95 29 Defining a Pop-Up Menu ................................................................................................................................... 95 30 Completing the Form ................................................................................................................................... 97 31 Form Hints ................................................................................................................................... 98 32 Changing Object Properties ................................................................................................................................... 98 33 Changing the Tab Order ................................................................................................................................... 98 34 Running the Custom Form ................................................................................................................................... 99 35 Summary ................................................................................................................................... 100 103Part VI Lesson 5 - Creating and Modifying Reports 1 Defining a Report ................................................................................................................................... 103 2 Creating an Employee Phone List ................................................................................................................................... 103 3 Building the Employee Phone List with the Report Wizard ................................................................................................................................... 104 4 The Report Designer ................................................................................................................................... 106 5 Modifying the Employee Phone List Report ................................................................................................................................... 107 6 Editing the Page Title ................................................................................................................................... 107 7 Changing the Column Headings ................................................................................................................................... 109 8 Resizing Objects ................................................................................................................................... 109 9 Report System Variables ................................................................................................................................... 110 10 Final Result ................................................................................................................................... 110 11 Previewing the Employee Phone List ................................................................................................................................... 111 12 Printing the Employee Phone List ................................................................................................................................... 111 13 Launching Files ................................................................................................................................... 113 14 Creating a Scheduled Flights List ................................................................................................................................... 114 15 Designing the Scheduled Flights Report ................................................................................................................................... 114 16 Building the Scheduled Flights Report ................................................................................................................................... 115 17 Report Sections ................................................................................................................................... 115 18 Removing Report Sections ................................................................................................................................... 116 19 Adding a Report Title ................................................................................................................................... 116 20 Changing the Size of the Detail Section ................................................................................................................................... 117 21 Placing Label (text) Objects ................................................................................................................................... 117 22 Aligning the Label Objects ................................................................................................................................... 118 23 Spacing the Label Objects ................................................................................................................................... 118 24 Placing DB Text (column) Objects ................................................................................................................................... 119 25 Placing a DB Memo (column) Object ................................................................................................................................... 120 26 Resizing and Aligning Column Objects ................................................................................................................................... 121 27 Saving and Previewing the Scheduled Flights Report ................................................................................................................................... 122 28 Modifying the Scheduled Flights Report ................................................................................................................................... 123 29 Adding a Format for Null Values ................................................................................................................................... 123 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. Contents IV 30 Adding a Breakpoint ................................................................................................................................... 123 31 Placing Objects in the Break Header ................................................................................................................................... 124 32 Adding a Display Format ................................................................................................................................... 125 33 Choosing DB Calc over using a computed variable in reports ................................................................................................................................... 126 34 Adding a Daily Total object using DB Calc ................................................................................................................................... 126 35 Placing Objects in the Report Footer Section ................................................................................................................................... 127 36 Adding a Grand Total DB Calc object ................................................................................................................................... 127 37 Changing Printing Styles ................................................................................................................................... 128 38 Finishing the Report ................................................................................................................................... 128 39 Saving and Closing the Report ................................................................................................................................... 128 40 Printing the Scheduled Flights Report ................................................................................................................................... 129 41 Summary ................................................................................................................................... 129 42 Tips ................................................................................................................................... 130 135Part VII Lesson 6 - Creating and Modifying Labels 1 Building a Label ................................................................................................................................... 135 2 Designing a Mailing Label ................................................................................................................................... 135 3 Building a Label for a Customer Mailing List ................................................................................................................................... 136 4 Defining Variables for the Label ................................................................................................................................... 137 5 Placing Objects on the Label ................................................................................................................................... 139 6 Placing the Remaining Objects ................................................................................................................................... 139 7 Previewing the Label ................................................................................................................................... 139 8 Saving and Closing the Label ................................................................................................................................... 140 9 Line Compression ................................................................................................................................... 140 10 Summary ................................................................................................................................... 143 145Part VIII Lesson 7 - Using R:BASE Commands 1 Opening the R:BASE R> Prompt ................................................................................................................................... 145 2 Using the Help at the R> Prompt ................................................................................................................................... 145 3 R:BASE Command Syntax ................................................................................................................................... 145 4 Using R:BASE Commands at the R> Prompt ................................................................................................................................... 146 5 Using Variables and Expressions ................................................................................................................................... 148 6 Summary ................................................................................................................................... 150 152Part IX Lesson 8 - Writing Command Files 1 Using The R:BASE Editor (RBEDIT) ................................................................................................................................... 152 2 Designing And Writing A Command File ................................................................................................................................... 152 3 Testing The Command File ................................................................................................................................... 154 4 Enhancing The Command File ................................................................................................................................... 154 5 Summary ................................................................................................................................... 157 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. IV V R:BASE 7.6 Beginners Tutorial 159Part X Lesson 9 - Creating and Using an Application 1 Designing an Application ................................................................................................................................... 159 2 Identifying the Tasks Skyapp Will Perform ................................................................................................................................... 159 3 Organizing the Tasks Into Menus ................................................................................................................................... 160 4 Building an Application ................................................................................................................................... 160 5 Creating Menu Actions to Enter Data ................................................................................................................................... 162 6 Creating Menu Actions to Edit Data ................................................................................................................................... 165 7 Creating Menu Actions to Print Data ................................................................................................................................... 167 8 Assigning Actions to the Flights and Exit Menus ................................................................................................................................... 169 9 Defining the Main Menu ................................................................................................................................... 170 10 Defining the Employees Main Menus ................................................................................................................................... 171 11 Defining the Flights and Exit Menus ................................................................................................................................... 173 12 Final Steps ................................................................................................................................... 173 13 The Application Designer Environment ................................................................................................................................... 174 14 Testing an Application ................................................................................................................................... 174 15 Testing the Employees Menu ................................................................................................................................... 174 16 Testing the Customers Menu ................................................................................................................................... 176 17 Testing the Flights Menu ................................................................................................................................... 177 18 Exiting the Application ................................................................................................................................... 177 19 Modifying an Application ................................................................................................................................... 178 20 Running an Application ................................................................................................................................... 178 21 Summary ................................................................................................................................... 178 180Part XI Lesson 10 - Maintaining a Database 1 Backups ................................................................................................................................... 180 2 What to Back Up ................................................................................................................................... 180 3 Checking the Database ................................................................................................................................... 181 4 Copying Database Files ................................................................................................................................... 181 5 Understanding R:BASE BACKUP and RESTORE ................................................................................................................................... 181 6 Backing Up Database Structure ................................................................................................................................... 182 7 Backing Up Database Data ................................................................................................................................... 183 8 Backing Up a Database ................................................................................................................................... 184 9 Confirming the Backup File was Created ................................................................................................................................... 184 10 Restoring a Database ................................................................................................................................... 184 11 Using the Restore command ................................................................................................................................... 185 12 The UNLOAD Command ................................................................................................................................... 186 13 Compressing the Database ................................................................................................................................... 186 14 Pack In Place Versus Reload ................................................................................................................................... 187 15 Using the Pack In Place Option ................................................................................................................................... 187 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. Contents VI 16 Using the Reload Option ................................................................................................................................... 187 17 Summary ................................................................................................................................... 188 190Part XII Glossary 1 A ................................................................................................................................... 190 2 B ................................................................................................................................... 191 3 C ................................................................................................................................... 191 4 D ................................................................................................................................... 191 5 E ................................................................................................................................... 192 6 F ................................................................................................................................... 192 7 I ................................................................................................................................... 192 8 K ................................................................................................................................... 192 9 L ................................................................................................................................... 192 10 M ................................................................................................................................... 193 11 N ................................................................................................................................... 193 12 O ................................................................................................................................... 193 13 P ................................................................................................................................... 193 14 Q ................................................................................................................................... 193 15 R ................................................................................................................................... 193 16 S ................................................................................................................................... 194 17 T ................................................................................................................................... 194 18 V ................................................................................................................................... 194 Index 195 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. VI Part I