SQL query (AREV Specific)
At 26 OCT 1998 03:52:57PM Serguei Poliakov wrote:
I have got the following problem with AREV:
When I issue any SQL command on a table with a large number of data and symbolic fields it shows message ?Compiling protection code? and hangs up.
I found that if I delete %PROTECT.SPEC% entry in the table dictionary SQL command works (but the %PROTECT.SPEC% entry is recreated when I later list dictionary).
What is happening? What is the entry %PROTECT.SPEC% for?
Serguei
At 01 NOV 1998 02:19PM Aaron Kaplan wrote:
The protect.spec is something that's created for SQL selects and works with the normalization and data typing of the fields. There is no way to stop the system from creating it. The hanging seems to happen when the protection code starts to exceed a certain threshold, but I never really delved that deeply into that section of the code to know it that intimately any longer.
Best suggestion I have is to contact Revelation and open up an incident. They can at least walk through the source code with you instead of having to rely on my memory.
