>>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.
Thanks, that looks like exactly what I need!
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright