This topic is locked

change fields in lookup wizard on the fly

9/4/2018 8:21:53 AM
PHPRunner General questions
G
georgweber author

Good morning, everyone
I would like to do the following:

I am making a reservation system with following tables
Table room: number, size, floor

Table reservation: number, name, date
Now I'm making an add page for a reservation. For the field room I do a Lockup Wizard. There I would like to show only those rooms which are still free on the added date on the add page.
I think that's only possible on the fly.
Can someone help me please

R
ringlis1 9/12/2018

When you are entering in the information in the Lookup Wizard screen, you can use the WHERE field to run an SQL statement to generate the information you are looking for.
You could make it display all records that is not already booked for a date depending how your data is structured

admin 9/13/2018

Yes, using WHERE clause you can only select rooms that are available for the selected date range. I believe that you need to use SQL variables to refer to selected FROM and TO dates.

https://xlinesoft.com/phprunner/docs/sqlvariables.htm