Consultor Eletrônico

Status: Unverified

FACT(s) (Environment):

OpenEdge 10.0B

SYMPTOM(s):

Error 7312 with linked Dynamic Combos after upgrading dynamics


QUERY-OPEN for query <name> requires a previous QUERY-PREPARE. (7312)

After upgrading dynamics to 10.0B02, dynamic combos linked via a parent filter query that worked fine in 10.0A01, fail at startup with error 7312.

Combo base query built with the Query Builder.

CAUSE:

The cause is unknown at the time of writing but it is related to the dynamic combo query after the parent filter query is inserted into it.

FIX:

In order to correct the problem modify the combo query so that it is correct. It will be necessary to view the dynamic combo query, so do this by running "showQuery" in the handle of the dynamic combo. The you should be able to identify in the query string where the problem occurs. Then modify the base query accordingly. As an example, modify the query:


FOR EACH hdm_employee NO-LOCK,
EACH gsm_user WHERE gsm_user.user_full_name = hdm_employee.employee_name
AND NOT gsm_user.disabled NO-LOCK
BY hdm_employee.employee_name

TO:



FOR EACH hdm_employee NO-LOCK,
EACH gsm_user NO-LOCK WHERE gsm_user.user_full_name = hdm_employee.employee_name
AND NOT gsm_user.disabled
BY hdm_employee.employee_name