How to create a wildcard search form (with Base/FireBird)?
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: 1) I get a parameter input popup, instead of linked to the master field, 2) Error "Incorrect type for setString", 3) 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?!
Hello,
It will be much easier to assist if you post a sample of the Base file without personal or confidential info.
@Ratslinger: posted!