>Unlike most programmers I let the user control what the user queries. The can query from 1 to 30,000. If they do that it would be user hostile for me to double the time required.
>
>In VFP 9 this does not need to "double the time required". You can merely ZAP the grid's RecordSource and INSERT INTO myalias SELECT * FROM SomeTables WHERE SomeCondition.
>
>The other alternative is to use a parameterized view.
>
>Unlike some programmers, I try to protect my end users from shooting themselves in the foot. I have found over the years that even if I give them exactly what they asked for, when they get it they can sometimes realize that it wasn't really what they wanted. Part of my job is to protect them from this.

My users are not shooting themselves in the foot even though I've given them more control. I recommend they not pull all records, but I don't prevent them. I give them the tools that let them do what they need to do. Parameterized views interfere with giving them this control. I teach them to use the gun and recommend they engage the safety. I don't take away the automatic repeat. I don't tell them to go buy VFP 9 just so I can use more recent SQL syntax either. Most of my clients complain bitterly about typical software. I empower them. That's how I see my job.