Consultor Eletrônico



Kbase 16473: Field Lists Generate a GPF with AS/400 V8.1A Client
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   5/10/1998
Status: Technically Reviewed

FACT(s) (Environment):

AS/400 database

FACT(s) (Environment):

Windows 3.1

FACT(s) (Environment):

Windows 95

FACT(s) (Environment):

Progress 8.1A

SYMPTOM(s):

Windows clients connect to AS/400 database via TCP/SNA

GPF on Windows client.

Specifying field lists in an OPEN QUERY statement.

FIX:

The first example below will generate a GPF. However, there is a temporary workaround for you not to get a GPF, but we cannot guarantee that field lists will work properly with this workaround. The 2nd example below will not GPF and as you can see, the only difference is the WHERE TRUE clause in the OPEN QUERY statement.

1) DEFINE QUERY q1 FOR customer FIELDS (cust-num name).
  DEFINE BROWSE b1 QUERY q1 DISPLAY cust-num name WITH 17 DOWN.
  OPEN QUERY q1 FOR EACH customer NO-LOCK.
  ENABLE b1.
  WAIT-FOR WINDOW-CLOSE OF THIS-PROCEDURE.

2) DEFINE QUERY q1 FOR customer FIELDS (cust-num name).
  DEFINE BROWSE b1 QUERY q1 DISPLAY cust-num name WITH 17 DOWN.
  OPEN QUERY q1 FOR EACH customer WHERE TRUE NO-LOCK.
  ENABLE b1.
  WAIT-FOR WINDOW-CLOSE OF THIS-PROCEDURE.


This issue has been fixed in release 8.1B.