Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question Unanswered: How to get table attribute names from a MS ACCESS DB using PowerBuilder

    Does anyone know if there's any way to get a table's attribute names (using an SQL query or something like that)


    i found that i can get the tables names using this query:


    SELECT Name from MSysObjects where Type = 1


    MSysObjects is a system table in MS ACCESS holding information about the DB objects (Tables, relationships, etc.)

    Apparently theres no Table specifying the DB table's attributes.

    i need to implement a PowerBuilder function that receives a valid table name and returns an array of strings containing the names of each of the table attributes.


    Any help?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There is a ton of information at MSDN about Defining and retrieving a database's schema. I don't think it will be too hard to do using PowerBuilder, but you won't be able to just paint a DataWindow from a SQL SELECT statement.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •