I’m querying the database for records by date. When the user chooses another date, I want the Table backed by a SQLContainer to reload with matching the new date.
I have the form working once, when constructed with a TableQuery, Filter, SQLContainer, and Table. I used a Filter, “new Compare.GreaterOrEqual”.
How do I pass a fresh value to that Filter and make the query update and the Table redraw with fresh rows?
I suppose this is 2 questions…
(1) How do I use PreparedStatement with a TableQuery, and pass parameters values?
(2) How to make the TableQuery re-execute?
–Basil Bourque