At present time the FrontBase interface in Beta is available on the following platforms: Solaris and Linux
Although FrontBase is also available for Windows this is not supported by the Beta interface. The client library supplied by Frontbase requires Apple's WebObjects.
You can download FrontBase at
http://www.frontbase.com(push download at the top of the screen and follow the instructions given).
Installing FrontBase on Solaris:
Log on as 'root', and type the following:
tar -xvf <the .tar file just downloaded> sh install.sh
Installing FrontBase on RedHat Linux:
Log on as 'root', and type the following:
rpm -i <the .rpm file just downloaded>
FrontBase/bin/sql92A small example: start sql92 and type the following:
create database firstdb; connect to firstdb user _system; create user firstuser; disconnect current; connect to firstdb user firstuser; disconnect current;
Almost everything is done the same way as when communicating with Oracle, ODBC etc.
The two major differences:'~beta/betadbc/betadbc-frontbase'
<your connection>.selecthost
Please note that shared variables is currently not possible when using the FrontBase interface. Suggested workaround: build your SQL statement dynamically using append or putformat.
A small example:
ORIGIN '~beta/betadbc/betadbc-frontbase'; -- program: Descriptor -- (# frontbaseCon: @Connection; stmt: @frontbaseCon.DirectSQLStatement; do 'brage.mjolner.dk' -> frontbaseCon.selecthost; ('firstdb','firstuser','')->frontbaseCon.open; 'create table Students("Name" varchar(100), "Age" integer);'->stmt.open; stmt.execute; stmt.close; frontbaseCon.close; #)
The following table shows the possible types of data in FrontBase, and the type to which they are mapped in Beta:
Boolean | booleanObject |
Integer | integerObject |
SmallInt | integerObject |
Float | realObject |
Real | realObject |
Double precision | realObject |
Numeric | realObject |
Decimal | realObject |
Char | text |
VarChar | text |
Bit | Unsupported type | VarBit | Unsupported type |
Date | time (with hh:mm:ss = 00:00:00) |
Time | time (with yy-mm-dd = 00-01-01) |
TimeTZ | Unsupported type | Timestamp | time (with both date and time set) |
TimestampTZ | Unsupported type |
YearMonth | Unsupported type |
DayTime | Unsupported type |
CLOB | Unsupported type |
BLOB | Unsupported type |
http://www.frontbase.comDocumentation on the SQL92 standard (a.k.a. SQL2), which is met by FrontBase:
http://www.frontbase.com/docs/5.html http://cui.unige.ch/db-research/Enseignement/analyseinfo/SQL92/BNFindex.html http://www.contrib.andrew.cmu.edu/~shadow/sql/sql2bnf.aug92.txt
The BetaDBC Library - Reference Manual and Tutorial | © 1999-2002 Mjølner Informatics |
[Modified: Thursday November 9th 2000 at 16:07]
|