Can you please explain how does this grid events work?
Scenario: I have a simple grid with modal form, wizard generated.
I added a lookup (dbludropdown) to the form and MySQL logs shows that every time I check the link in the grid to open the modal form, the lookup is refreshed for the whole dataset (not only the records on screen but the complete dataset).
For example: the grid says "1 of 10 records, 14 total", and I select the link to edit ANY record, the MySQL log shows 14 distinct selects on the lookup field.
I'm looking for a way to prevent those selects, and to understand the behaviour of these events.
I know I can set a detail grid to not update the parent grid when selecting a row by setting the mastergrids property. Is there something like that for a grid/modal form pair?
If you create a lookup, then it needs to apply the resultset based on the key. As PHsPeed caches results by default this would mean that you might not get the correct result set. That is why the caching is set to false on lookup datasets. But if the resultset can be reused and does not change, set the caching of the used lookup table to true.
Thank you very much, I'm re-reading the manual section on caching, it seems I need to better understand how it works...
If things are unclear, then let us know, and we'll try to enhance them. It is a 'living' document. PHsPeed is loaded with functionality, and it is challenging to document all and keep the stuff readable. Any feedback and help is appreciated.
Btw, we are also interested in features that our customers are missing so we can enhance the product further.