Announcement

Collapse
No announcement yet.

using sqlTools to get database information

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Shawn Anderson
    replied
    that's enough to get me started. Thanks fellas.

    Leave a comment:


  • Eric Pearson
    replied
    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.
    Last edited by Eric Pearson; 11 Jan 2008, 12:00 PM.

    Leave a comment:


  • Michael Mattias
    replied
    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.)

    Leave a comment:


  • Shawn Anderson
    started a topic using sqlTools to get database information

    using sqlTools to get database information

    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
Working...
X