>>>>>
>>>>>If you're using SQL Server, this information is already available to use in various meta-tables (views)
>>>>>
>>>>>Say, you can check Information_Schema.Columns to get information about columns and you can look into extended properties to get descriptions of the fields (if you need to get this information too).
>>>>
>>>>I will look into this approach. Thank you.
>>>
>>>Yes, it sounds like it will work nicely. You get the schema for particular table using
>>>

>>>select * from Information_Schema.Columns where Table_Name = 'MyTable' and schema_name = 'dbo'

>>>and then you construct your SelectCMD and other commands using that info.
>>>
>>
>>It is strange that when I execute the above command (changing schema_name to table_schema) in SQL Server SMMS, I get a nice table where each row is information on a column in a table. When I execute this command from VFP, I get a table with no records where each column name is the name of the column in the table. Do you know why it is so?
>
>What do you mean by when you execute it from VFP? Try also only to get Column_Name and type for now.

Sorry. I am just losing my f.... mind <g> It was my bad.