On Mon, Feb 2, 2009 at 11:31 AM, Paul McNett <[email protected]> wrote: > MB Software Solutions General Account wrote: >> I agree with Paul, here. That's how I've been designing my apps (to run >> a VFP app locally accessing a MySQL database over the web) and they run >> great. Thanks again to Paul's MakeUpdatable.prg and Bob Lee's >> conference session at WhilFest many years ago for pointing me in that >> direction. > > But you must put in a way for the user to cancel a long query, or not allow > queries > like "select * from invoices". I put in hard limits of 500 and 1000 records > depending > on the context, and nobody ever complained. ---------------------------------------------
How do you do EOM or EOY processing then? ;-> Do you just run update statements against the server or do you grab the data and locally decide if it needs to be archived? <brings back years of SBT/AccPac hell here> -- Stephen Russell Sr. Production Systems Programmer First Horizon Bank Memphis TN 901.246-0159 _______________________________________________ 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.

