Hello,
I have a _list page based on a table. This table may be filtered through a query. My sql query which I have in the Before SQL query event is:
query='
SELECT newfloor.propID
FROM newfloor
GROUP BY newfloor.propID, newfloor.FloorType, newfloor.LeaseSale, newfloor.Availabley
HAVING (
( (newfloor.FloorType)<>"PEXT" Or (newfloor.FloorType)<>"PINT" Or (newfloor.FloorType)<>"ARCH")
AND (newfloor.Available)=True '. $_SESSION["minmax"] . $_SESSION["type"]. $_SESSION["thtk"].')';
$strWhereClause='PropID in ('.$query.')' .$_SESSION["regio"];
This query is running well.
In the _view page of a individual record based on the filtered/queried table there are the 3 standard buttons : previous record, back to list, and next button.
Clicking the previous or next button in the _VIEW page moves the _view page to the next record in the original (unfiltered) table NOT to the previous or next record of the filtered/queried table.
What code am I missing? Any advice is welcome.
Yves.