Subject | RE: [IBO] TIBOQUERY filter and CachedUpdates |
---|---|
Author | |
Post date | 2017-09-05T18:05:41Z |
Hi Jason,
I upload a little test named "pb_ibo_2".
I use :
- the employee.FDB database.
- a IBOQuery to show the EMPLOYEE table ("SELECT * FROM EMPLOYEE ORDER BY EMP_NO")
- a TDBGrid to show the fields : EMP_NO, FIRST_NAME, FULL_NAME, PHONE_EXT.
- A TRadioGroup to play with the Filter property on the PHONE_EXT Field.
1) Open the DB
2) go to the employee #72 (phone_ext is null)
3) Enter "1" and press enter
4) Click on filter "phone_ext" is null
5) you show the #72 in the list with a value
I added a checkbox to open the database with or without the CachedUpdates enabled. When the CachedUpdates is disabled, the filter works.
Best regards,
Laurent.