
Is there a limit in query characters contained in a procedure ?
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
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?
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
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.