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().