SELECT a_glhent.gldate AS trandate, a_glhent.glmodule AS jr, a_glhent.trtype AS typ, a_gldent.batchno AS batch, a_gldent.glseqno AS seqno, a_gldent.gltdes AS descript, IIF(a_gldent.credit, (a_gldent.glamnt * -1), a_gldent.glamnt) AS amount FROM a_glhent, a_gldent WHERE &lc_where ORDER BY trandate INTO CURSOR a_detail
STANDARD
Press <Enter> to view source entry,
<Esc> to exit
ENTER
DO l_setsql WITH "ENTRY", "STANDARD", "", "", a_detail->batch, a_detail->seqno, a_detail->typ