Subject RE: [IBO] Refresh question
Author Jason Wharton
Post date 2017-09-17T16:24:50Z
You won't have the ability to refresh those columns until after the updates are applied.
This is one of the weaknesses of using cached updates.

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.
Jason

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Monday, September 11, 2017 8:07 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Refresh question

Hi all,


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 :


      SELECT *

      FROM EMPLOYEE

      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 ...


Best regards,

Laurent.