Hi. We are running Arev 3.11 on Novell 3.12, and I have a table that got too big to purge the rows from. I've even copied everything onto a non-network pc, and it still gives me the "maximum number of variable records exceeded…." error message. I looked at sizelock, and it is set to 0. The OV file is 15 megs, and the LK file is 32 megs. Does it sound like somthing is corrupted? I'm trying to copyrow about one months worth (maybe 30,000 rows) of data to another table, and it bombs about 5% into the process. Is the only way around this to write a routing to read/write/delete the rows one at a time? Thanks for any help… -Mick-

When copying, try putting (SE at the end of the statement. Usually it's the messages that overflow variables.

If you are using a SELECT statement, you might try putting a row limiting number within the statement. Such as:

SELECT 10000 table_name …

The number can be what ever you want. It will cause you to have to run your purge process several times to get it all but I assume that is better than not being able to do it at all.

Michael Slack

Thanks Larry and Michael, I'll give both of these a try tonight. I've been working on this at home to see what will finally work before I do it on our live system at work. Thanks again….

-Mick-

The (SE did the trick. It froze once in win95, so I tried it in Dos-Mode, and it worked. Thanks again! -Mick-

No problem, glad to help.

I've got a number of FAQs on Rev/AREV issues on my website - you might want to copy them for future reference.

http://www.tardis.cc

Larry Wilson

larry@tardis.cc

TARDIS Systems, Inc.

View this thread on the forum...