I’m trying to create a wildcard search/filter form as shown in the tutorial by TheFrugalComputerGuy.
Here’s a simple test setup which I can’t get to work:
Created table Words (id INT, word VARCHAR) and put in some words.
Created table FilterWords (id BOOL, FilterWord VARCHAR) (will only have one row at a time).
Created a form. MainForm has as data source the FilterWords table. Added the field FilterWord to it. Added a button which saves the form. FilterWords table is updated corectly on saving.
Added a subform with a TableControl for displaying the Words table. Set the data content type to SQL query, and put in:
SELECT * FROM “Words”
WHERE (word LIKE :VAR_word || ‘%’) OR (:VAR_word IS NULL)
Configured Link master field to “FilterWord”; slave field to “VAR_word”.
Now I run into a few problems:
- I get a parameter input popup, instead of linked to the master field,
- Error “Incorrect type for setString”,
- Subform is not refreshing / filtering on the filter value.
I tried adding a button with Refresh action but got more errors and/or it was grayed out.
Hopefully I’m just missing something silly. Thoughts?!