>>>We have a database consisting of over 100 tables. I use ADBOBJECTS() to get a list of tables in the database. Now I need to get a list of the fields in each table.
>>>
>>>I know AFIELDS() will do this but I would prefer not to have to USE each table in order to get the fields list. Is there another function similar to ADBOBJECTS() that will allow me to do this?
>>>
>>If you just want a hardcopy you can use the application in Solutions if you're in vfp5, it gives a good listing of a database with all rules, etc. If you have long field names you'll need to modify things just a little...
>
>I need the field names in an array or cursor. I'm faced with creating my own ad-hoc query builder that will work either with a local database or through ODBC to a backend server. With ODBC I can use SQLCOLUMNS(). I need something similar to that.
Oh. Well, you could take a look at the Solutions app that does the report I mentioned. Thet have to get the info before the report is run, after all...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.