The BetaDBC Library - Reference Manual and Tutorial

Mjølner Informatics Report
MIA 99-43
March 2004

Contents
1 Introduction
2 How to use the BetaDBC interface
2.1 Introduction
2.2 Setting up your system
2.2.1 On Windows
2.2.2 On Unix
2.3 Initializing a database
2.3.1 Frontbase
2.3.2 MySQL
2.4 Writing the Beta code
2.4.1 Including an interface
2.4.2 Opening a connection
2.4.3 SQL Statements
2.4.4 Declaring Shared Variables
2.4.5 Using shared variables
2.4.6 Results
2.4.7 Specifics for the native Oracle interface
2.4.8 Specifics for the native Frontbase interface
2.4.9 Specifics for the native MySQL interface
3 BetaDBC Interface Tutorial
3.1 Introduction
3.2 Creating a Database
3.3 Querying and Retrieving from the Database
3.4 Executesqlfile
3.5 Embedded SQL - Using Shared Variables
3.6 Embedded SQL - Fetching Results
3.7 An Ad-hoc Query Evaluator
4 Text Files for the Tutorial
4.1 createmoviedbtables.txt
4.2 deletemoviedbtables.txt
4.3 populatemoviedbtables.txt
5 Transactions
6 Scrolling Cursors
7 Datatypes
7.1 Types in Oracle and Beta
7.2 Types in FrontBase and Beta
7.3 Types in MySQL and Beta
8 References
9 Interface Descriptions
9.1 Betadbc Interface
9.2 Scrollingresultset Interface
9.3 Tables Interface
9.4 Transactions Interface
Index
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
PDF (96kb)
Copyright © 1999-2004 Mjølner Informatics.
All rights reserved.
No part of this document may be copied or distributed
without the prior written permission of Mjølner Informatics

The BetaDBC Library - Reference Manual and Tutorial
 © 1999-2004 Mjølner Informatics
[Generated: Tuesday June 29th 2004 at 13:16]