Stephen Russell wrote:
> 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? ;->
Well, I was talking about user-generated queries. If the system requires a
million
rows to download, then of course you allow it. But it would be nice to display
a
progress bar I guess.
> Do you just run update statements against the server or do you grab
> the data and locally decide if it needs to be archived?
It depends on the context. I'd try to make a thin-but-tall select query
("select id,
label from table") and when the user requests detail a fat-but-short query
("select *
from table where id = ?") runs. Perhaps some background querying if we can
predict
that the user will be visiting some of these records in a few minutes.
Paul
_______________________________________________
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.
