Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Forms & Form designer
Environment versions
Network:
Windows 2000 Server
>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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only