Kbase P123910: Dynamics Auditing details doesn't show any records
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/05/2007 |
|
Status: Unverified
SYMPTOM(s):
Dynamics Auditing details doesn't show any records
Using European numeric format the Auditing details window does not show any records for the entity being audited.
getEntityDisplayField needs to use the Quoter function when building its WHERE clause in the General Manager.
CAUSE:
This is a known issue being investigated by Development
FIX:
As a work around, change the Dynamics General Manager af/app/afgenmngrp.i internal procedure getEntityDisplayField from:
/*Build the where clause*/
IF ttEntityMnemonic.table_has_object_field THEN
ASSIGN
cWhereClause = TRIM(ttEntityMnemonic.entity_mnemonic_description) + ".":U + TRIM(ttEntityMnemonic.entity_object_field) +
" = ":U + pcOwningValue.
ELSE IF NUM-ENTRIES(ttEntityMnemonic.entity_key_field) = NUM-ENTRIES(pcOwningValue,CHR(1)) THEN DO:
To:
/*Build the where clause*/
IF ttEntityMnemonic.table_has_object_field THEN
ASSIGN
cWhereClause = TRIM(ttEntityMnemonic.entity_mnemonic_description) + ".":U + TRIM(ttEntityMnemonic.entity_object_field) +
" = ":U + QUOTER(pcOwningValue).
ELSE IF NUM-ENTRIES(ttEntityMnemonic.entity_key_field) = NUM-ENTRIES(pcOwningValue,CHR(1)) THEN DO:
Recompile the general manager.