Paul McNett wrote: > 1) Maintain a cursor of valid order numbers on the VFP side. For > example, to start with: > > sqlexecute(handle, "select OrderNo from orders order by OrderNo ASC", > "order_nums") > > select order_nums > index on OrderNo tag OrderNo > > > 2) When it comes time to view the next/previous order, use the cursor > you created in 1 to find the next or previous order number, and then > execute sql like: > > * Next > SELECT * FROM Orders WHERE Orders.OrderNo == (clastOrderNumber) >
Yeah, that's exactly what you should do. I did that actually in the late 90s, but it was all VFP and I had changed the app to use local views (but employed the same concept). _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** 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.