AlphaDAO Objects

The Alpha Five Enterprise edition provides Xbasic program access to SQL databases such as  Microsoft SQL Server, Oracle, MySQL as well as  Microsoft Access. This functionality extends the familiar Alpha Five database features that previously supported only .DBF files.

AlphaDAO provides the following SQL objects. Each object has properties and methods.

Object

 

Description

SQL::Argument

V8

This object defines a single argument to be passed to a SQL function in a SQL::Arguments collection.

SQL::Arguments

V8

A collection of arguments to be passed to a SQL function.

SQL::CallResult

V8

This object provides a more complete description of a function call on an object in the SQL name space.

SQL::Connection

V8

Each instance of SQL::Connection represents a potential or active database session.

SQL::DataTypeInfo

V8

A single column in a table or result set. The description includes the name, size, precision, Alpha Five type, the native type, and an intermediate type (see SQL::IntermediateType ) which contains more precise type information. This intermediate type makes it possible to recreate a table using the closest possible matching type in the target table.

SQL::IndexColumnInfo

V8

A description of one of the columns in an index.

A SQL::IndexInfo contains one or more columns that make up the primary key, the foreign key, of a unique or non-unique index.

SQL::IndexInfo

V8

A description of an index on a SQL table. Each table in a SQL database has one or more relationships, constraints or indexes. The primary key, foreign keys, and unique and non-unique indexes are each described by a SQL::IndexInfo instance. The SQL::TableInfo object contains a list of those indexes.

SQL::ResultSet

V8

A collection of rows returned from the execution of a query. When a SQL query returns one or more rows of data, you can use the SQL::ResultSet object to get the description of the result set and to navigate within the rows of the results to retrieve the data.

SQL::Row

V8

The data returned by the SQL::ResultSet.NextRow() method.

SQL::Schema

V8

A collection of SQL table definitions. SQL::Schema is a container for one or more SQL::TableInfo objects.

SQL::TableInfo

V8

A fairly complete description of a SQL table, its columns, and its indexes. Many of the SQL functions either ask you to provide a SQL::TableInfo object, or will create one for you. Using this object, it is possible to retrieve a description of a table from one database and construct a copy of that table in the same or another database.

See Also

Working with SQL Databases

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.