>>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only