|Subject||RE: [IBO] Refresh question|
What you could consider doing is using calculated fields and then you would be able to have them kept up to date with a little extra work.
For IBO to handle this in the way you are expecting, I'd have to totally parse the entire statement and manually perform the JOIN in memory. While this is possible, it would be very complicated.
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, September 11, 2017 8:07 AM
Subject: [IBO] Refresh question
I've a technical question about a query with joins : After inserting a new record, I don't know how to refresh all the columns coming from the joins. CachedUpdates is on and the changes are just posted...
For example, if you have a query like :
LEFT JOIN DEPARTMENT ON DEPARTMENT.DEPT_NO = EMPLOYEE.DEPT_NO
LEFT JOIN JOB ON JOB.JOB_CODE = EMPLOYEE.JOB_CODE
AND JOB.JOB_GRADE = EMPLOYEE.JOB_GRADE
AND JOB.JOB_COUNTRY = EMPLOYEE.JOB_COUNTRY
ORDER BY EMP_NO
and a DBGrid to show and edit the data.
When you insert a new employee, the columns EMPLOYEE are updated but not the columns from the DEPARTMENT and the JOB tables...
The "refresh" doesn't work