SQL compatibility in ARev (AREV Specific)
At 21 NOV 2001 01:42:06AM Adil Yalcin wrote:
When I send an SQL statement via SQL window, System displays the following message and this process never ends. I need to do "End Task" in order to break the process.
+-R153———————–+
¦ ¦
¦ Compiling protection code… ¦
¦ ¦
+——————————+
At 21 NOV 2001 03:03AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
You probably do not have enough free memory to compile the protection code OR you have too many fields in the dictionary. Why do you need to use SQL? It isn't the most efficient way of querying AREV tables.
World Leaders in all things RevSoft
At 21 NOV 2001 08:30AM Dan Reese wrote:
My recollection is that this can occur if you have more than 300 fields in the dictionary of one of the tables in the query.
At 22 NOV 2001 06:18AM Andrew Gordon wrote:
Capturing the inline source code reveals that a sub. is written for each (protected) dict, so too many dicts and too many inpats/outpats will soon lead to source ]34K and therefore an aborted compilation.
If the author of the inline source-composer had written a single sub to loop through arrays of inpats/outpats, he could have had a very small piece of code that would always compile!
At 27 NOV 2001 02:35AM Adil Yalcin wrote:
Dear Sir / Madam
We have been asked for SQL compatibility of our database by government. For this reason, we need to demonstrate them some options of SQL in ARev.
If you could supply some more information, I would be grateful.
Regards
Adil Yalcin
At 27 NOV 2001 06:20AM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
Well if this is just a marketing check box then choose your smallest file in terms of rows and columns and just say
SQL SELECT * FROM TABLENAME
at TCL.
Should work fine!
World Leaders in all things RevSoft