>Hi Tamar,
>
>One thing I think might be useful is how to create a view when a SQL table has too many fields for VFP to read. I have found using an SP works well like: SQLEXEC(dsn,[exec sp_columns 'incident_name'],'c_columns'). Another route to take is to pull the data via sqltables() and sqlcolumns().

Thanks for the suggestion. In fact, this book is focusing only on SQL inside VFP, not working with SQL back-ends.

Tamar