How to get tables/fields from MySQL database to Nav with ADO

Steele

Hi there,

has anybody experience with retrieving tablenames/fieldnames from a MySQL using ADO
for example : AdoConnect.OpenSchema()

Global
Name DataType Subtype Length
AdoConnect Automation 'Microsoft ActiveX Data Objects 2.8 Library'.Connection

or maybe there is another way ?

thanx for your reply !

niscox

No but you can query the schema 'information_schema'
e.g.
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME FROM information_schema.COLUMNS;

Steele

Thanx a bunch !
you gave me the right direction !

it works !