Is there a good way to return the fields in a foxpro database?

[NSMan]

I'm completly new to foxpro, and I am doing something that requires me to create a script that converts a bunch of Foxpro databases into SQL tables.

I thought it'd be nice to have something that would return the fields in a paticular database, or all the databases in a directory. That way I could convert any foxpro database into a sql table without having to manualy reference every field from every foxpro database I'm going to accessing. Has anyone ever done anything like this before?

 

[alvechurchdata]

Lots of functions to help you here:

AFIELDS() will give you the fields in a table
ADATABASES() will give you open databases
ADIR() will give you files in a particular folder
AUSED() will give the open tables

All return the information in an array. If you look these up in Help and follow the See Also links then you'll find more.

fields in a paticular database

When you're looking through Help, remember that a database contains many tables and each table contain many fields.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[alvechurchdata]

Just realised that this is the forum for older versions of Fox - ignore what I said about databases. At that time Fox tables were referred to as "databases".

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[NSMan]

Yeah, I know, that one threw me for curvballs after using SQL Server