Kbase P84229: getRecordDetail does not work with _obj fields
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/06/2004 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics 2.1A
SYMPTOM(s):
getRecordDetail does not work with _obj fields
getRecordDetail does not return any records when used with European numeric format.
Using -E or -numsep 46 -numdec 44
CAUSE:
The decimal value of the _obj field must be enclosed in quotes before it is passed to getRecordDetail.
FIX:
Enclose the decimal _obj value in quotes before calling getRecordDetail. This can be done by physically enclosing the string in quotes or with the Quoter function. e.g.
DEFINE VARIABLE ObjComp AS DECIMAL.
DEFINE VARIABLE cFields AS CHARACTER.
DEFINE VARIABLE cquery AS CHARACTER NO-UNDO.
{ af/sup2/afglobals.i }
ObjComp = DYNAMIC-FUNCTION('getPropertyList' IN gshSessionManager,
'CurrentOrganisationObj', TRUE).
/* Enclose _obj in quotes */
/* RUN GetRecordDetail IN gshGenManager */
/* ("FOR EACH gsm_login_company WHERE " + */
/* "gsm_login_company.LOGIN_COMPANY_OBJ = " + */
/* "'" + STRING(ObjComp) + "'", */
/* OUTPUT cFields). */
/* Use QUOTER to enclose in quotes */
RUN GetRecordDetail IN gshGenManager
("FOR EACH gsm_login_company WHERE " +
"gsm_login_company.LOGIN_COMPANY_OBJ = " +
QUOTER(ObjComp),
OUTPUT cFields).
MESSAGE cFields VIEW-AS ALERT-BOX.