Kbase 13613: Query browser problem with 7.3 client to V6 server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Query browser problem with 7.3 client to V6 server
If you have a 7.3a client connecting to a 6.3e database server
and in your application you have a trigger on a button which
re-opens a browser query, ie:
ON CHOOSE OF BUTTON-1 IN FRAME FRAME-A
DO:
OPEN QUERY BROWSER-1 FOR EACH DEMO.CUSTOMER BY CITY.
END.
You will get an inconsistent number of records or NO
records returned to the browsers each time you click on
the button.
If you run the same code against a v7 database, locally or
remotely, then the code returns the correct number of records
to the browsers and it is always consistent.
This is logged as bug: 94-10-28-004 and is caused by the
fact that you are using a FIND and OPEN QUERY/GET on the same
buffer. The GET is causing progress to reposition the index
cursor when it shouldn't. This problem is planned to be
addressed in 7.4a.
The work-around to this problem is:
1) Connect to a version 7 server
OR
2) Sort on an indexed field when you open the query
OR
3) Use different buffers for the FIND and GET
Progress Software Technical Support Note # 13613