Hi ,

I am experiencing a very weird problem. I have run a export procedure dataease sudden force logout.Any solution.....?

DEFINE TEMP "MON" Numeric String 2 .
DEFINE TEMP "YEAR"Numeric String 4.
DEFINE TEMP "PAY" Numeric String 19.
DEFINE TEMP "NO" Numeric String 7.
for PPR WITH BANK not = "cash" ;
ASSIGN TEMP NO := COUNT OF PPR with ( BANK not = "CASH") .
ASSIGN TEMP MON := MTH .
ASSIGN TEMP YEAR := YR .
ASSIGN TEMP PAY := ( sum of PPR with ( BANK not = "CASH") EAR ) * 100
list records
TEMP NO;
TEMP MON ;
TEMP YEAR ;
TEMP PAY .

Thank you,

Manjula Pio

Hi Manjula.

The problem here is not the DQL but the underlaying data. 

We are pretty sure that the problem is a virtual field that you use in the DQL. Check the underlying tables if there is a virtual field that cause this.

It can be that the virtual field is based on corrupt data or a broken index. You can try to reorganise the underlying tables.