Hi Bill
> From: "William Sanders / EFG" <[EMAIL PROTECTED]> > Subject: re: [SQL2K] Replication to Foxpro > To: [EMAIL PROTECTED] > Message-ID: <[EMAIL PROTECTED]> > Content-Type: text/plain; charset="us-ascii" > > Point by point, but not in the original order as presented: > > 3. "Therefore, the application is not built with any form of paging > capability" > Ah - but it could be! With the same remote views into sql server, you can > set up the connection properties from vfp to not pull everything, and > limit each pull to 100 to 200 records. Then, as the pseudo-cursor is > moved (ie- go bottom) , VFP will force the odbc connection to get to the > end. There is a time lag, of course, but NOT for the initial VFP > form/screen load. > Actually, you can write queries that page through the data without ever seeing that go bottom delay. Select fields from table order by whatever top 100 where 1=1 now remember the last PK m.lastPK then when they click next ... select fields from table order by whatever top 100 where pk>m.lastPK _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
