General information
Category:
Coding, syntax & commands
>We are trying to find a way to speed up our APP at a clients site.
>
>Client:
>[snip]
Shawn -
here's a good concept that works:
1. Make the views you need REMOTE views with parameters. In the filter condition tab of the view designer - change the field name to something meaningful for that table, condition equals [=] and then in the Example place '?vp_cqueryval'.
2. In the data environment for the form, add that parameterized remote view.
In the data section of the PEM box set the 'NoDataOnLoad' to TRUE [.T.]
Then, after your form instantiates - your user would enter a client number
in the textbox, and in the click method of the button you assign the vp_cqueryval variable to the number that they typed in, and then issue a requery.
If it takes a long time for this, then your table isn't indexed properly.
hth [Bill]
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