Output contains only last record.

Owned by martinajindrova
Last updated: Dec 06, 2023
1 min read

KB-20231031-01

Version

Before XFRX 22.6

Symptoms 

Output contains only last record from many records.

Cause

  • Used XFRX#INIT.
  • Filled a parametr tcScopeClause or tcWhileClause of ProcessReport() method.
  • Some Expression or "Print when exprresion" use _PAGETOTAL variable.

Using  _PAGETOTAL cause two pass processing. First processing move record pointer to last record. Second processing process only last record, because scope clause or  while clause are filled.

Workaround

Use SET FILTER TO or SET KEY TO command and don't fill a parametr tcScopeClause and tcWhileClause.