>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 Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao