[stackoverflow] [progress Openedge Abl] Openedge Progress 4gl Query Returns (missing) After...

[thomasw_lrd]

DEFINE TEMP-TABLE tt_pay_terms NO-UNDO
FIELD pt_terms_code LIKE payment_terms.terms_code
FIELD pt_description LIKE payment_terms.description.
DEFINE VARIABLE htt AS HANDLE NO-UNDO.
htt = TEMP-TABLE tt_pay_terms:HANDLE.

FOR EACH platte.payment_terms
WHERE (
active = true
AND system_id = "000000"
)
NO-LOCK:
CREATE tt_pay_terms.
ASSIGN
pt_terms_code = payment_terms.terms_code.
pt_description = payment_terms.description.
END.

htt:WRITE-JSON("FILE", "/dev/stdout", FALSE).


I have written this query and it returns data like this

[pt_terms_code] => 0.4%!N(MISSING)ET46
[pt_description] => 0.4%! (MISSING)DAYS NET 46


While I believe (from using a SQL query) that the data should be

0.4%45NET46
0.4% 45 DAYS NET 46


I'm making an assumption that the % is probably some special character (as I've run into similar issues in the past). I've tried pulling all the data from the table, and I get the same result, (ie, not creating a temp table and populating it with all the only the two fields I want).

Any suggestions around this issue?

I'm still very new to 4gl, so the above query might be terribly wrong. All comments and criticisms are welcome.

Continue reading...