Subject | Re: IB_Query.InvalidateSQL and Refresh |
---|---|
Author | |
Post date | 2015-10-15T13:55:05Z |
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
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