In message #969317, you provided a solution on how to read a table structure. Is this only good when the table is within a database? For example, if I use OleDbDataAdapter to retrieve the data from a VFP free table and I would like to get the table struture of that table, would there be a similar approach that I could use? That solution assumed a SQL back-end, as it used the database information_schema.
If you've retrieved data from a free VFP table and you want to determine the structure, you could do the following. Assuming you have a dataset called DsReturn - you could iterate through the columns in the table object
foreach(DataColumn Dc in DsReturn.Tables[0].Columns)
The Data Column object Dc will have properties for column name, column type, etc.
There may be other ways to do it - that's the only one that immediately comes to mind.
Since you mentioned "free table", I'm guessing you mean something that's not part of the DBC. If you're using the container, it would be different.
Hope that helps...
Kevin