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.