Simplicty and flexibility!


Force logout


Started by Manjula Perera
Search
You will need to Sign In to be able to add or comment on the forum!

Force logout

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


Written by Manjula Perera 27/05/19 at 06:43:42 DataEase for Windows 5.x and before...

Re: Force logout

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.


Written by DataEase 27/05/19 at 10:27:56 DataEase for Windows 5.x and before...