Results 1 to 4 of 4
  1. #1

    Re: Qualifier in SQLGetSchema

    User (MMcNaughton@STSSystems.com.nospam) posted:

    Re 2.: For what DBMS, Oracle, SQL Server, getting this info is different
    for each.


  2. #2

    Re: Qualifier in SQLGetSchema

    User (MMcNaughton@STSSystems.com.nospam) posted:

    Re 1:

    A qualifier is a string that qualifies the search, as shown below:

    Action QualifierText
    3 The name of the database in the current data source.
    SQLGetSchema returns the names of the table owners in that database.
    4 Both a database name and an owner name. The syntax consists
    of the database name followed by the owner's name, with a period separating
    the two; for example, "DatabaseName.OwnerName". This function returns an
    array of table names that are located in the given database and owned by the
    given owner.
    5 The name of a table. SQLGetSchema returns information about
    the columns in the table.

    It seems you want Action 5, and for the qualifier you would put the name of
    the table for which you want the columns.


  3. #3

    Re: Qualifier in SQLGetSchema

    User Beal, Tai (Tai.Beal@ausinfo.com.nospam) posted:

    I use 5 for action and a table name for qualifier, but the return code
    is -1. I had luck with some other action values (just to prove this
    function works.)

    My db is MS Access.

    - tai

  4. #4

    Qualifier in SQLGetSchema

    User Beal, Tai (Tai.Beal@ausinfo.com.nospam) posted:

    I have two questions:

    1. What's the definition of qualifier$ in SQLGetSchema function? The
    online help doesn't document it.
    2. Are there other ways to find out the column names in a table of a
    data schema?

    - tai




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 04:08 PM.

Copyright BetaSoft Inc.