>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.
Thanks, by the time I read your message, I came up with that approach.