Does the ISELECT command (on mv.Enterprise)have limitations in the
number of operands that can be passed to it? I've created the indices
required, but can't seem to make the combination of date ranges,
customer numbers and part numbers execute properly. I receive this
error message:
[23] Invalid sentence: (followed by the command I've entered)

Thanks in advance for any help or advice.

Dave Morrison

mve had probs with Indexed files as far as I remember. We tried to use
it once too but found that firstly it wasn't exactly what it was
professing to be, and secondly wasn't all that much faster than the
normal file access mechanisms provided.

I don't know of any limitations to ISELECT but check your syntax again.

Could you maybe include that command that it echoes back so people can
at least do a human parse for errors ....

Thanks for your response. So far, the 'single' ISELECT command works
significantly faster than a regular SELECT, and matches items selected
perfectly. After some additional testing and analysis of returned
messages, I've made some changes to use ISELECT for the primary 'mass'
select, followed by a series of 'normal' SELECTs to trim the list down
further. mvE ISELECT does have its limitations in this context.

iakovos (AT) gmail (DOT) com wrote:

Ross,

Thanks for your response. That is exactly what I did and realized
ISELECT works well on the first shot, but abandons the initial list
upon any subsequent ISELECT commands. So I've just included some normal
SELECT commands following to trim down the list. It still out performs
a normal select by a long shot.

Dave