An Easy Question 1

[iliasKBS]

I am a new VB programmer and I am conencting to mySQL server via DAO and mySQL ODBC connector. Is there direct way to retrieve the table and fields names? mySQL does not support the adSchemaColums property to give me the fields names in one pass. I saw a code where the schema for the fields is retrieved in a two way procedure. But i am getting reslts if i do TWO connections. One to get the table , and a second to get is fields:

Set someTables = someConnection.OpenSchema(adSchemaTables)

Set someFields = someConnection.OpenSchema(adSchemaColumns,Array(Empty, Empty, someTables("TABLE_NAME&quot.Value,Empty))

AND THIS IS SLOW!! The driver re-eastablishes connection for every table I am asking fields.

 

[sleipnir214]

"SHOW TABLES" will give you a list of tables in the currently-selected database.

Issuing the query "DESCRIBE tablename" or "SHOW COLUMNS FROM tablename" will get you a list and description of columns of a table



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[newbiepg]

how do you display all the databases?
from the command prompt.

 

[JustKIDn]

sleipnir,

Good clear, simple answer.

I gave you a S T A R !!!

BTW: Congratulations getting to be the top poster for the week!



tgus

____________________________
Families can be together forever...

 

[sleipnir214]

tgus:
Thanks!

newbiepg:
It's considered impolite to piggyback your question on another member's thread.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!