Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What to do when user SQL Selects too much?
Message
De
21/03/2006 17:01:51
Mike Yearwood
Toronto, Ontario, Canada
 
 
À
21/03/2006 13:14:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01105674
Message ID:
01106423
Vues:
38
>Hi,
>
>>You two have been at this for 8 hours! If you were boxers you'd be leaning on each other, head-to-head :-)
>
>Nah. Long intervals between punches and I'm just ducking in and out (with a bit of weaving <g>)
>
And I've got the flu or something. It's simply misunderstanding. you're saying you would not send the data if there is too much. I intepreted what you said to mean the user would be told - "sorry you're stupid - you can't execute a query like that". If you're saying you'd do what google does, then I'm with you. I let the user query as they will and I prepare a list for them. It never is all the data. I control the columns that are presented in the list. They navigate that list and access the records they want. I show a thermometer while the list is being built and let them escape from the query.

We don't have a built in way to do google-like pagination, so it's my compromise.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform