Subject Re: IB_Query.InvalidateSQL and Refresh
Author
Hello,

I am using 5.5.3.2095 and I see this behavior in sys_open also. I see this when I use orderlinglinks and dbgrid. When I click on the column to change the ordering the application loops.

I did see in my data that when I let out blob fields this also helps besides working with small datasets.

I notified that setting AutoFetchAll to True this behavior disappears also and that seems the overall workaround for now..

I don't think this is the desired behaviour but couldn't yet find a other solution.

I did look in the searchinglinks-example and when I put in a blob field in the employee table and set AutoFetchAll to False you can see the same behaviour by clicking on the LAST_NAME column.

  SALARY SALARY NOT NULL,
/* blob field added*/
  BLOB_FIELD BLOB SUB_TYPE TEXT SEGMENT SIZE 1024,
  FULL_NAME COMPUTED BY (last_name || ', ' || first_name) );

Werner