Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What to do when user SQL Selects too much?
Message
From
21/03/2006 17:01:51
Mike Yearwood
Toronto, Ontario, Canada
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01105674
Message ID:
01106423
Views:
36
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform