Date:  11/02/2006 08:23:30 AM Msg ID:  003194
From:  Gary Thread:  003194
Subject:  Indexing Remote Views
Foxweb 2.11/VFP6.0
MS IIS/ MS SQL
 
I am using a Database with remote views to access data on a MS SQL server.  A particular view returns almost 800 records.
 
If I do nothing to the table I can skip thru all records and display the information I want.
 
If I try to index the table, it will only go thru the first 665 records then stop.  I onened the view in VFP, Indexed, and listed the records and everything is ok, but not thru Foxweb.
 
I checked the index fields and all data is ok. It does not matter how much info of each record I display, it always stops at the same place. I do not get any error messages. This view can be sorted several ways for reports and I did not want to create a seperate view for each report.
 
Any suggestions?