Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    4

    Question Unanswered: Help: Code Snip to get Database Information

    Ok here's what i had in mind:

    I have a database ( lets call it sample ). In the database I have oh 2 tables. Table1 and Table 2. In each of these tables I have fields id, name and um phone.

    So here is what it looks like:

    Sample
    -------------
    - Table1
    ... id
    ... name
    ... phone

    - Table2
    ... id
    ... name
    ... phone

    What I need is a code snip that will walk threw the database and display the information in a HTML format. I know you can connect to a table and do a For Each x in Fields then x.name to get the field name. Is there another version of this so that I can connect to a database ( for example: sample ) and have a code do a For Each tbl in Tables to get the table name then do a for each x in fields to get field name from the table?

    I have a few projects that this would help me out on.
    Thanks for your time.

  2. #2
    Join Date
    Sep 2003
    Posts
    4
    OK I think i have found something that will work for me.

    ADO OpenSchema does what i need to do.


    But now im running into a small problem. For example now when
    I use objRS2.Fields(i).type i get a numeric value for an answer. Is
    there a MySQL Const referance to these values?
    I guess what Im looking for now is something like this:

    Const adErrCantChangeConnection = 3748 'Connection was denied

    or some type of referance chart to let me know that a INT = 3.

    -Thanks

Posting Permissions

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