R:BASE Turbo V-8 Beginners Tutorial
202 Pages
English
Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

R:BASE Turbo V-8 Beginners Tutorial

-

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

Description

Turbo V-8
Beginners Tutorial
The End-User's Guide to Building
R:BASE Databases and Custom Applications
R:BASE Technologies, Inc. R:BASE Turbo V-8
Beginners Tutorial
by R:BASE Technologies, Inc.
Welcome to R:BASE Turbo V-8 for Windows
Welcome to the Next Generation R:BASE Turbo V-8 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 Turbo V-8 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 Turbo V-8 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. R:BASE Turbo V-8 Beginners ...

Subjects

Informations

Published by
Reads 112
Language English
Document size 5 MB

Exrait

Turbo V-8 Beginners Tutorial The End-User's Guide to Building R:BASE Databases and Custom Applications R:BASE Technologies, Inc. R:BASE Turbo V-8 Beginners Tutorial by R:BASE Technologies, Inc. Welcome to R:BASE Turbo V-8 for Windows Welcome to the Next Generation R:BASE Turbo V-8 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 Turbo V-8 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 Turbo V-8 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. R:BASE Turbo V-8 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 Turbo V-8 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 71Part V Lesson 4 - Creating and Modifying Forms 1 Designing a Form ................................................................................................................................... 71 2 The Form Designer ................................................................................................................................... 71 3 Creating a Quick Form with the Form Wizard ................................................................................................................................... 71 4 Understanding the Form Designer Interface ................................................................................................................................... 73 5 Customizing the Form Designer Environment ................................................................................................................................... 73 6 Field Object Properties ................................................................................................................................... 74 7 Customizing the Form ................................................................................................................................... 76 8 Editing Text Objects ................................................................................................................................... 76 9 Changing the Size of Objects ................................................................................................................................... 78 10 Moving Objects ................................................................................................................................... 79 11 Aligning Objects ................................................................................................................................... 80 12 Entering and Editing Text Objects ................................................................................................................................... 81 13 Creating a Bevel ................................................................................................................................... 82 14 Placing an Analog Clock ................................................................................................................................... 83 15 Additional Objects ................................................................................................................................... 83 16 Form Properties ................................................................................................................................... 83 17 Saving and Closing Forms ................................................................................................................................... 83 18 Testing the Form ................................................................................................................................... 84 19 Running the Form ................................................................................................................................... 84 20 Creating a Custom Form ................................................................................................................................... 84 21 Using Expressions and Variables ................................................................................................................................... 86 22 Placing Objects ................................................................................................................................... 87 23 Placing Text Objects ................................................................................................................................... 88 24 Placing DB Edit (column) Objects ................................................................................................................................... 88 25 Placing Variable Objects ................................................................................................................................... 89 26 Placing DB Memo (scrolling) Objects ................................................................................................................................... 90 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. II III R:BASE Turbo V-8 Beginners Tutorial 27 Placing a DB Lookup Combo Box ................................................................................................................................... 91 28 DB User Defined Combo Box ................................................................................................................................... 94 29 Defining a Pop-Up Menu ................................................................................................................................... 94 30 Completing the Form ................................................................................................................................... 96 31 Form Hints ................................................................................................................................... 97 32 Changing Object Properties ................................................................................................................................... 97 33 Changing the Tab Order ................................................................................................................................... 97 34 Running the Custom Form ................................................................................................................................... 98 35 Summary ................................................................................................................................... 99 102Part VI Lesson 5 - Creating and Modifying Reports 1 Defining a Report ................................................................................................................................... 102 2 Creating an Employee Phone List ................................................................................................................................... 102 3 Building the Employee Phone List with the Report Wizard ................................................................................................................................... 103 4 The Report Designer ................................................................................................................................... 105 5 Modifying the Employee Phone List Report ................................................................................................................................... 106 6 Editing the Page Title ................................................................................................................................... 106 7 Changing the Column Headings ................................................................................................................................... 108 8 Resizing Objects ................................................................................................................................... 108 9 Report System Variables ................................................................................................................................... 109 10 Final Result ................................................................................................................................... 109 11 Previewing the Employee Phone List ................................................................................................................................... 110 12 Printing the Employee Phone List ................................................................................................................................... 110 13 Launching Files ................................................................................................................................... 112 14 Creating a Scheduled Flights List ................................................................................................................................... 113 15 Designing the Scheduled Flights Report ................................................................................................................................... 113 16 Building the Scheduled Flights Report ................................................................................................................................... 114 17 Report Sections ................................................................................................................................... 114 18 Removing Report Sections ................................................................................................................................... 115 19 Adding a Report Title ................................................................................................................................... 115 20 Changing the Size of the Detail Section ................................................................................................................................... 116 21 Placing Label (text) Objects ................................................................................................................................... 116 22 Aligning the Label Objects ................................................................................................................................... 117 23 Spacing the Label Objects ................................................................................................................................... 117 24 Placing DB Text (column) Objects ................................................................................................................................... 118 25 Placing a DB Memo (column) Object ................................................................................................................................... 119 26 Resizing and Aligning Column Objects ................................................................................................................................... 120 27 Saving and Previewing the Scheduled Flights Report ................................................................................................................................... 121 28 Modifying the Scheduled Flights Report ................................................................................................................................... 122 29 Adding a Format for Null Values ................................................................................................................................... 122 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. Contents IV 30 Adding a Breakpoint ................................................................................................................................... 122 31 Placing Objects in the Break Header ................................................................................................................................... 123 32 Adding a Display Format ................................................................................................................................... 124 33 Choosing DB Calc over using a computed variable in reports ................................................................................................................................... 125 34 Adding a Daily Total object using DB Calc ................................................................................................................................... 125 35 Placing Objects in the Report Footer Section ................................................................................................................................... 126 36 Adding a Grand Total DB Calc object ................................................................................................................................... 126 37 Changing Printing Styles ................................................................................................................................... 127 38 Finishing the Report ................................................................................................................................... 127 39 Saving and Closing the Report ................................................................................................................................... 127 40 Printing the Scheduled Flights Report ................................................................................................................................... 128 41 Summary ................................................................................................................................... 128 42 Tips ................................................................................................................................... 129 134Part VII Lesson 6 - Creating and Modifying Labels 1 Building a Label ................................................................................................................................... 134 2 Designing a Mailing Label ................................................................................................................................... 134 3 Building a Label for a Customer Mailing List ................................................................................................................................... 135 4 Defining Variables for the Label ................................................................................................................................... 136 5 Placing Objects on the Label ................................................................................................................................... 138 6 Placing the Remaining Objects ................................................................................................................................... 138 7 Previewing the Label ................................................................................................................................... 138 8 Saving and Closing the Label ................................................................................................................................... 139 9 Line Compression ................................................................................................................................... 139 10 Summary ................................................................................................................................... 142 144Part VIII Lesson 7 - Using R:BASE Commands 1 Opening the R:BASE R> Prompt ................................................................................................................................... 144 2 Using the Help at the R> Prompt ................................................................................................................................... 144 3 R:BASE Command Syntax ................................................................................................................................... 144 4 Using R:BASE Commands at the R> Prompt ................................................................................................................................... 145 5 Using Variables and Expressions ................................................................................................................................... 147 6 Summary ................................................................................................................................... 149 151Part IX Lesson 8 - Writing Command Files 1 Using The R:BASE Editor (RBEDIT) ................................................................................................................................... 151 2 Designing And Writing A Command File ................................................................................................................................... 151 3 Testing The Command File ................................................................................................................................... 153 4 Enhancing The Command File ................................................................................................................................... 153 5 Summary ................................................................................................................................... 156 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. IV V R:BASE Turbo V-8 Beginners Tutorial 158Part X Lesson 9 - Creating and Using an Application 1 Designing an Application ................................................................................................................................... 158 2 Identifying the Tasks Skyapp Will Perform ................................................................................................................................... 158 3 Organizing the Tasks Into Menus ................................................................................................................................... 159 4 Building an Application ................................................................................................................................... 159 5 Creating Menu Actions to Enter Data ................................................................................................................................... 161 6 Creating Menu Actions to Edit Data ................................................................................................................................... 164 7 Creating Menu Actions to Print Data ................................................................................................................................... 166 8 Assigning Actions to the Flights and Exit Menus ................................................................................................................................... 168 9 Defining the Main Menu ................................................................................................................................... 169 10 Defining the Employees Main Menus ................................................................................................................................... 170 11 Defining the Flights and Exit Menus ................................................................................................................................... 172 12 Final Steps ................................................................................................................................... 172 13 The Application Designer Environment ................................................................................................................................... 173 14 Testing an Application ................................................................................................................................... 173 15 Testing the Employees Menu ................................................................................................................................... 173 16 Testing the Customers Menu ................................................................................................................................... 175 17 Testing the Flights Menu ................................................................................................................................... 176 18 Exiting the Application ................................................................................................................................... 176 19 Modifying an Application ................................................................................................................................... 177 20 Running an Application ................................................................................................................................... 177 21 Summary ................................................................................................................................... 177 179Part XI Lesson 10 - Maintaining a Database 1 Backups ................................................................................................................................... 179 2 What to Back Up ................................................................................................................................... 179 3 Checking the Database ................................................................................................................................... 180 4 Copying Database Files ................................................................................................................................... 180 5 Understanding R:BASE BACKUP and RESTORE ................................................................................................................................... 180 6 Backing Up Database Structure ................................................................................................................................... 181 7 Backing Up Database Data ................................................................................................................................... 182 8 Backing Up a Database ................................................................................................................................... 183 9 Confirming the Backup File was Created ................................................................................................................................... 183 10 Restoring a Database ................................................................................................................................... 183 11 Using the Restore command ................................................................................................................................... 184 12 The UNLOAD Command ................................................................................................................................... 185 13 Compressing the Database ................................................................................................................................... 185 14 Pack In Place Versus Reload ................................................................................................................................... 186 15 Using the Pack In Place Option ................................................................................................................................... 186 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. Contents VI 16 Using the Reload Option ................................................................................................................................... 186 17 Summary ................................................................................................................................... 187 189Part XII Glossary 1 A ................................................................................................................................... 189 2 B ................................................................................................................................... 190 3 C ................................................................................................................................... 190 4 D ................................................................................................................................... 190 5 E ................................................................................................................................... 191 6 F ................................................................................................................................... 191 7 I ................................................................................................................................... 191 8 K ................................................................................................................................... 191 9 L ................................................................................................................................... 191 10 M ................................................................................................................................... 192 11 N ................................................................................................................................... 192 12 O ................................................................................................................................... 192 13 P ................................................................................................................................... 192 14 Q ................................................................................................................................... 192 15 R ................................................................................................................................... 192 16 S ................................................................................................................................... 193 17 T ................................................................................................................................... 193 18 V ................................................................................................................................... 193 Index 194 Copyright © 1982-2011 R:BASE Technologies, Inc. All rights reserved. VI Part I