R/List (OpenInsight 32-bit Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 29 JUN 2007 10:20:58AM Marty Rosenbloom wrote:

OpenInsight 32-bit Specific

Hi,

I have the following snippet of code in use:

CMD1= LIST SALES ID-SUPP BY DEPARTMENT BY CLASS RESERVATION JustLen "C" DEPARTMENT JustLen "C" BREAK-ON CLASS JustLen "C" TOTAL FINAL_SALE TOTAL FINAL_RETURNS NET_SALES TOTAL LINE_COMMISSION TOTAL SECURITY_MID JustLen"8" TOTAL SECURITY WITH WEEK_ENDING EQ '

Along with some other code this works fine. As soon as I add the word TOTAL in front of NET_SALES I get an error telling me that I have encountered an illegal expression. I am using OI 7.2. Any insight into this would be appreciated.

TIA,

Marty

At 29 JUN 2007 12:05PM Warren Auyong wrote:

There seems to be a line length issue with the OI compiler. Break up the CMD1 assignment into one or more concatenates.

Also all the keywords must be uppercase or they get ignored. This should be changed in v8.0x

At 29 JUN 2007 08:33PM Marty Rosenbloom wrote:

Warren,

That did the trick. I broke it into two commands and it worked. I didn't know that there was a character limit in the command.

Thanks,

Marty

At 30 JUN 2007 12:30AM Warren Auyong wrote:

It's not in the command line but in the compiler, it seems to truncate assignment lines at some point

View this thread on the forum...