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:
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.
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.