Revisited SQL Error - 302 (AREV Specific)
At 30 OCT 2002 01:21:19PM Martin Peck wrote:
I have seen one other thread regarding this topic but my issue does not appear to be related to memory so hopefully someone can help me out.
Particulars:
AREV 2.08
Avail Mem: 236220 (at WHO)
Problem:
This works at the command prompt:
: SQL SELECT fldname FROM WHATEVER WHERE fldname=A"
This works at the SQL window:
SELECT fldname FROM WHATEVER WHERE fldname=A"
This DOES NOT work in a program:
EXEC SQL
SELECT fldname FROM WHATEVER WHERE fldname=A"END EXEC
*** I get the same error that everyone else is getting which is SQL-302 – "The file on SQL_OBJ is not available."
Am I missing a file or something? I am a novice in AREV and I recently had to setup SQL capabilities. I added the TRANSACT volume and everything seems to run fine except when I put it in a program.
Any assistance is appreciated.
Marty Peck
At 30 OCT 2002 01:34PM [url=http://www.sprezzatura.com" onMouseOver=window.status= Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote:
That isn't a lot of available memory at all - especially for SQL stuff. We'd suggest ensuring expanded memory is available, ensuring it is available to data as well as programs (/X as well as /M4096) and taking the usual steps to free up low memory.
World Leaders in all things RevSoft
At 31 OCT 2002 10:55AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
In addition to my fellow Sprezzling, are you sure you have a SQL_OBJ file available? It should be in the REVBOOT volume and attached to this specific account.
Also, the syntax for the EXEC SQL command you are using may not completely correct. You should have the INTO keyword to have a place for the result list.
World Leaders in all Things RevSoft
At 31 OCT 2002 12:58PM Martin Peck wrote:
First of all…Thanks for the help.
Yes, the SQL_OBJ file does exist. Thank you for letting me know the location. I had a heck of time trying to find it.
Secondly, you are right, the EXEC SQL statement is incorrect but I copied/pasted it for ease of writing my message. It is correct in my code.
That only leaves memory. I saw your other post so I will look into those options.
Thanks again for the help,
Marty
At 31 OCT 2002 02:16PM Martin Peck wrote:
OK. I tried. Nothing seems to work with regards to memory.
Expanded is available.
I followed the PIF instructions that are on this website.
And, I even closed Win98…rebooted…and booted to a DOS session using F8.
I "remmed"-out everything in ConFIG and AutoExec so that only EMM386 was running.
I typed C:]MEM at the prompt and it said that I had 621K available in conventional with another 4Mb in expanded.
Yet, when I run AREV /X/4096 the most memory that I have seen available is 272000K.
EM Used says 507000K
EM Allocated=4Mb
If you think of anything else please let me know. Thanks for the help.
Marty