I have a query, created programmatically in OI (converted from AREV code) that looks like this:

SELECT DEMOGRAPHICS USING QUERY (WITH BW FROM '0' TO '999') BY-DSND BW

Now this query works fine in AREV but when I try:

Run RList "SELECT DEMOGRAPHICS USING QUERY (WITH BW FROM '0' TO '999') BY-DSND BW"

I get the following error:

(WITH is an invalid dictionary item

Now it works without the parens but I need them as some pretty complex queries get created with lot's of OR's and AND's.

Any sugestions?

Thanks,

Bryan

Bryan,

I think it's something very simple :)! Just leave a space between the ( and WITH.

I tried it first without a space and I got the exact error message you got. With a space in between the two it works like a charm. Obviously, a change in the interpreter from ARev to OI.

Dave

P.S. Since you're looking at converting Arev to OI, let me know if you can use a utility I wrote for myself that allows you to still work with @record/@pseudo and then "post" the contents of the variable to the window controls. It did cut down my conversion time for commuter routines by about 80-90% (since I didn't have to change the @record assignements to set_property/get_property).

I appreciate the offer but I'm all done with the screens. I just started on the query system. We've created our own query system that is extremely user friendly for the users.

Thanks for the help on the parens, I'll give it a try.

Bryan

Dave,

 You sound like just the person I need to talk to. We

are thinking of converting from AREV to OI. I know absolutley

nothing about OI, but have been using AREV off and on for

about 7 years. The main table that I use is one which contains anywhere from 800,000 to 1,000,000 rows on a given day.

Any broad-based comments and or suggestions would be greatly appreciated.

                          Thanks in Advance,

                          Mike Fasano

                          fiz@arn.net

View this thread on the forum...