>>Larry
>>
>>Looks like it does not work for Oracle. Any other ideas?
>>
>>
>>>>Ok, I give up! Well, I haven't spent too much time on it because I know some of you know the answer. I have tried creating a view against certain tables in SQL Server 7 and VFP chokes with an error message sayign too many columns. I also tried using Sqlcolumns() and got the same thing. Is there a way to iterate through the column names in VFP?
>>>
>>>You could use SPT and use the SP_COLUMNS system stored procedure for this. You could iterate through the resulting cursor.
>>>
>>>Ex.
>>>=sqlexec(lnconn,[exec sp_columns 'mytable'],'c_columns')
>>>
>>>HTH.
>
>Change the SQL code to
>[select column_name from user_tab_cols where table_name = 'mytable';]
>
>Oracle doesn't have a nice SP wrapper for this stuff.

Larry, thanks.