Simplicty and flexibility!


Is there a limit in query characters contained in a procedure ?


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

Is there a limit in query characters contained in a procedure ?

Hi ,

Is there a limit in the total amount of characters that a procedure can contain?

I am experiencing a very weird problem. I have a procedure with a huge amount of characters. dataease sudden force logout.Any solution.....?

Thank you,

Manjula Pio


Written by Manjula Perera 23/01/19 at 13:09:43 DataEase for Windows 5.x and before...

Re:Is there a limit in query characters contained in a procedure ?

About 40000 (40K) characters in a DQL and 9 nesting levels.

DataEase build a view based on the DQL which can be extreemly complex and hence use a lot of memory etc.

The solution is simply to divide up your DQL into smaller DQLs and run them from a control procedure etc.

Have you tried running the DQL in ExecDQL?


Written by DataEase 26/01/19 at 21:37:29 DataEase for Windows 5.x and before...

Re:Re:Is there a limit in query characters contained in a procedure ?

No ,I haven't try ExecDQL.Can i know how to run the DQL in ExecDQL.

Thank you

Manjula Pio


Written by Manjula Perera 14/02/19 at 08:24:24 DataEase for Windows 5.x and before...

Re:Re:Re:Is there a limit in query characters contained in a procedure ?

Hi again. It was just a question to see if there was any difference as it would tell us if the problemis in the GUI part of the DQL.

The best solution anyhow is to split your DQL into smaller more manageable DQL's and fire them from a control procedure.


Written by DataEase 15/02/19 at 12:11:59 DataEase for Windows 5.x and before...