MFS and Query Window (AREV Specific)
At 21 SEP 1999 06:39:39AM Bill Titus wrote:
I am experiencing a problem running a query (from a window or SELECT statement) against a file with SHELL.MFS installed. I receive error message 189 "Error encountered during the REDUCE process. Code: 0." I started with a functional MFS which worked in every other respect but this one, then pulled back to the SHELL.MFS to find the problem. No such luck. The file is indexed, so SI.MFS is also installed as the second value in the media map as: SHELL.MFS²SI.MFS. Is there something I'm missing that can account for this problem?
TIA for your help.
At 21 SEP 1999 10:45PM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
What's the query? Reduce errors are generally not caused by an MFS.
akaplan@sprezzatura.com
At 22 SEP 1999 05:50PM Bill Titus wrote:
Thanks for your response, Aaron.
The query is simple: SELECT DONORS WITH ID BETWEEN "1" AND "200"
The ID has a btree index on it; no Quickdex/Rightdex installed. There are approximately 12000 records in the file. Without the SHELL.MFS installed, the SELECT works fine.
At 22 SEP 1999 11:18PM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
A basic MFS can't just be put on. Some of the commands need to be returned and not passed on to the next system.
Flush, Install and Onmi.Script should just return back.
akaplan@sprezzatura.com
At 23 SEP 1999 08:08AM Bill Titus wrote:
"Flush, Install and Onmi.Script should just return back." In the SHELL.MFS from the old UTILITY.PROGS file, carried along with each ARev update, which is all that I'm using at this point, FLUSH and INSTALL are set to TRUE$ and appear to do just that. There is no Omni.Script. Could this be the problem?
I run into the problem with SELECTs on every field, not just indexed fields, when run from TCL or the equivalent PERFORM. If I select records using Ctrl-F10 | Browse Options | Indexed Columns, the select is performed without difficulty. If I then pull the command from the command stack and rerun it, I get error 189. When I eliminate SHELL.MFS from the media map, all returns to normal.
Thanks again for your time and your help.
At 23 SEP 1999 11:51AM Victor Engel wrote:
If memory serves, OMNI.SCRIPT is used only in some versions. Unfortunately, I don't have docs handy stating which.
At 25 SEP 1999 01:16PM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura Group[/url] wrote:
The Developer's Series contained a new SHELL.MFS for later versions. Try using that. Sorry, I don't keep mine expanded so I don't know which one it's in, but probably 2 or 3.
akaplan@sprezzatura.com