Hi !

need some help

I try to make a sql select but it appears

Sql-302

The file on "filename" is not available

Thanks

This error implies that whilst AREV is aware of the existence of the file, it is unable to access it…

Are you working off a CD copy of the system you forgot to unflag read only? What is your exact SQL statement?

The Sprezzatura Group

[i]Celebrate CeBIT with Sprezz Local![/i]

Before nothing, thanks for help me

I have arev ver 2.1 installed in a netware 5.0

and have an aplication running but I'm trying to

do is some sql querys to the database.

and the exact command is :

SELECT REF FROM ARTICULOS WHERE ARTICULO_NO=1344"

there is a table named "ARTICULOS" and have a lot

of information I can see it with a List comand and

it has the fields REF and ARTICULO_NO within.

What is going on ?

thanks

Mario

You're welcome!

OK so at TCL you are typing

SQL SELECT….

or from the SQL window

SELECT…

but you can see the rows if you go to TCL and type LIST ARTICULOS…

We'd suspect some form of out of memory condition when compiling the protection code needed for SQL to work.

How much memory do you have available (type WHO at TCL)?

The Sprezzatura Group

[i]Celebrate CeBIT with Sprezz Local![/i]

Yes I did :

I did have memory troubles with an error 252 (in the same command)

and I did a search on this page and found the command :

arev /M4096X

to try solve it, but now I having this error when I make

the sql query, I did it from the sql window.

This is the information that I have on who command :

                 before /M4096X            After /M4096X

EM used 343,040 394,240

EM allocated 8,388,608 4,194,304

After the sql statment I did another who check :

EM used 463,872

EM allocated 4,194,304

I hope this information was usefull.

Thanks.

That helps immensely -

try RESTRICTING the available EMS memory to 4096 in the shortcut PIF - you should never allow more than 4MB

AREV /X /M4096

AND

set this in the PIF.

The Sprezzatura Group

[i]Celebrate CeBIT with Sprezz Local![/i]

Hi

I do enter to my application by a batch file :

@ECHO OFF

G:

CD \APLIC\AREV

AREV DISTEX /X /M4096

CD \

I made the changes; before it read (AREV DISTEX /M4096X)

and made the changes in the pif shorcut changing the memory tab to EMS Memory total to 4096.

Also made the exact changes to the memory tab at properties on .bat file.

But the problem still appears.

I try changing all the memory fields to 4096 but the program

doesn't work and I try changin to a low level of mem closer to 4096

(I review the mem at who command) but the error continues.

I appreciate your effort, thanks.

Well, you did in fact answer your own question. An FS252 is an "out of memory when trying to compile r/basic code" and in this case it NEEDS the R/BASIC code to access the files via SQL. It can't compile the code so it can't access the files.

The only way around this is to make sure that more LOW memory is available to AREV - it should be 350K+ at the WHO prompt. Try loading DOS high etc etc.

We would query though why you are using SQL - it isn't the most efficient way to access AREV data - AREV is denormalised and SQL is designed to work off normalised tables or views with only one data element per tuple. AREV can easily have multiple data elements per tuple. (This sort of posting takes me back - when I started programming in the late '70s/early '80s normalised referred to exponents and mantissas not data structures . I wonder what tuple will mean in 20 years).

The Sprezzatura Group

[i]Celebrate CeBIT with Sprezz Local![/i]

Dictionary.com has two definitions. I think there's another definition, too. What is a sex tuple, for example? Could it relate to this snippet of code I found today?

CASE @RECORD="

 L.ERROR=9                             ;*MUST HAVE SEX

The history isn't funny ?

The error 252 not longer appear since the /M4096 attribute

was set, but now I have the sql 302 error.

now with arev enviroment I see have sql capabilities

so I start to read the documentation here but

when I start to make some test of commands

this problem appear.

I'm advice this is not a common database with "denormalised"

tables, but in the documentation that I have seems to ease

like on Informix or another sql based database. Thas why I

now testing.

You think if I made a program, compile it and run this

problem skip the lack of memory ? I going to try it.

Could you please tell me what reffer the etc ?

Thanks

Try logging off and repeating the exercise. If you get an out of memory error again then this is the problem and will need to be resolved before you can do SQL statements. (See earlier post about low memory/high memory).

Failing that, do you have remote access available?

The Sprezzatura Group

[i]Celebrate CeBIT with Sprezz Local![/i]

View this thread on the forum...