RoyBaird
Posts: 115
|
| Posted: 06/25/2010, 8:32 AM |
|
2 dependent listboxes: Master selects the GROUP, slave selects the TYPE. Both work fine except the slave does not filter on the second where clause. The table has multiple entries for a GROUP, but only 1 for a TYPE. Now it shows all entries for a GROUP. It does not appear to see the"type = 'Medical'" where clause.
I have looked in the code (PHD) of the service and all I see is "{SQL_Where}" and I cannot find where that gets loaded.
Any help is much appreciated!!!
_________________
Roy |
 |
 |
hidran
Posts: 29
|
| Posted: 07/27/2010, 9:54 AM |
|
Add a beforeshow event to the grid service and
echo $Component->DataSource->Where
in order to know its where clause
|
 |
 |
|