Oklahoma City. We may be calling or have already contacted you regarding coming to help.


We have several large processes that currently traverse the tables. Using parameterized remote views. Unless I'm missing something, this is incredibly wrong and should be SQL statements, either in stored procedures or spt from Fox.

btw, one other big question I have is on the main customer table which is large.
Is the only (good) way to go ahead and parameterize the view and force searches to pull up one customer at a time or is there a good way to "page" say 100 at a time. I've tried FETCHSIZE but it seems to lock the connection and can't update. I'm now using MAXRECORDS and the go bottom button goes to the last of the "page" recordset then increases MAXRECORDS to itself + 100 and re-queries. And yes, I'm embarrassed about that.
What I would like to find is a way to keep only say 100 at a time locally, not progressively more.

Any advice you have to offer is greatly appreciated.
I have your book, Client/Server Applications with VFP and SQL Server
Chad

chad@linville.net
AOL IM: chad9991