using sqlTools to get database information

[Shawn Anderson]

I'm using sqlTools to manipulate a mySql database.

Is there a way to:
1) query a column to tell me the type of cell it is (int, varchar, etc.)
2) query a table to find out how many columns are in it

On another project, I'm using sqlTools to manipulate an Access (MDB) file.
Some of the tables have relationships. Can I get the main table data with its related data in a single query?

thanks

[Michael Mattias]

On another project, I'm using sqlTools to manipulate an Access (MDB) file.
Some of the tables have relationships. Can I get the main table data with its related data in a single query?

That's handled by the SQL statement in the WHERE clause. Any number of column values from as many different tables may be retrieved in a single SQL statement. (I'm sure there is some limit somewhere but I've never encountered it).

If you need help creating the SQL statement, please post a 'for instance' and I'm sure someone can get you started.

MCM
(PS I know SQL tools has "catalog functions" so you might check your SQL Tools' help file under "catalog"). The catalog functions give you table names, column names, columns data types, etc.)

[Eric Pearson]

Actually Shawn had the right word... SQL Tools calls them "information" functions not catalog functions.

Database Info
Table Info
Table Column Info
Result Column Info
etc.

For example SQL_TableColumnInfoStr (SQL_TblColInfoStr) provides information about the columns in a table in String form (i.e. the return value of the function is a string) so it can be used to retrieve column names, etc.

Also check out the sample programs that are provided. Most of the Info functions are demonstrated.

-- Eric Pearson, Perfect Sync, Inc.

[Shawn Anderson]

that's enough to get me started. Thanks fellas.