Overview

Alpha Five's Enterprise software gives you the ability to read and write to back-end database products in a manner similar to the way you would read and write to an Alpha Five table. The term "back-end database" refers to the following ODBC compatible database products which support the SQL query language.

Database

Driver

Syntax

FlexQuarters QODBC

QuickBooks

 

IBM DB2™

DB2

 

InterSystems Cache™

ODBC

ODBC

Microsoft Access™

Access

 

Microsoft Excel™

Excel

 

Microsoft SQL Server

SQLServer

 

MySQL™

MySQL

 

Oracle XE™, 9i, 10g

Oracle

 

Oracle Lite™ (9i, 10g)

OracleLite

 

Quantel™

ODBC

ODBC

Sybase Adaptive Server Enterprise™

ODBC

Sybase

Sybase SQLAnywhere™

ODBC

SQLAnywhere

Alpha Five continues to add support for other products, so if your favorite back-end database is not on the list, check with Alpha Software. In addition, the generic ODBC driver will support many database products that are not listed.

Alpha Five implements the back-end database connectivity with genie dialogs and an extensive tool kit of objects named AlphaDAO. AlphaDAO provides Action Scripting and Xbasic compatible functions that will let you:

In addition, you can access a back-end database to:

The advanced user will also find tools that allow him or her to:

Naturally, the standard access and security features of your back-end database still apply, and ultimately control any actions that you can take.

Supported By

Alpha Five Version 8 Enterprise Edition

Limitations

Desktop applications only.

See Also

Working with SQL Databases