More about the SQL::Connection Object
While working in the Interactive window, after creating the conn SQL::Connection object, you could type.
The result would be a long list of methods and properties available to SQL::Connection objects. Here are a few methods and properties that might be of immediate value. For a full description, see SQL::Connection Object.
To get a list of tables in the alphasports.mdb database, you would use the SQL::Connection::ListTables() method.
To find out whether the connection was open, you would read the .IsOpen property.
To get the primary key expression for a table, you would use the SQL::Connection::PrimaryKeyExpression() method.
To validate the syntax of SELECT statement before sending it to the back-end database, you would use the SQL::Connection::ValidateQuery() method. Note that this method does not find field or table name errors.
dim select_exp as C
select_exp = "select * from customer"
Close the connection when you are finished.
Alpha Five Version 8 Enterprise Edition
Desktop applications only.
Working with SQL Databases, SQL::Connection Object