SQL select, unless you are searching a huge table(s) with really complex relationships...or if you are fetching a huge chunk of data...should be very fast. A few seconds at the worst.
Try building the select statement incrementally to see what triggers the slow response time. If the size of the data returned is the issue, think about how you might fetch just a subset of the data. Mike Copeland -------- Original Message -------- Subject: listbox behavior in FPW 2.6 From: Michael Madigan <[email protected]> To: [email protected] Date: 4/19/2012 8:53 AM As a temporary fix, I want to remove the browse windows from Foxpro. We are just using it as a pick list, no data is being entered. We select the row, hit escape, and the program seeks to the correct record. Can i use a list box and will that prevent refreshing issues across a network? I don't care if it's refreshed or not, but will it still be vulnerable to damaging index tags? I tried doing a SQL select, but it just takes too long to do what we want it to do even if it's optimized correctly. [excessive quoting removed by server] _______________________________________________ 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 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.
