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