× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hi Darrell,

In RPGLE free format, you do not need to use a plus sign ("+") for line continuation, only for variable concatenation. So this

somestr = +
 '(' + %trim(sheetname1) + '!' + %trim(cellname) + '+' +
       %trim(sheetname2) + '!' + %trim(cellname) + '+' +
       %trim(sheetname3) + '!' + %trim(cellname) + '+' +
       %trim(sheetname4) + '!' + %trim(cellname) +
  ')';

should be this

somestr = '(' + %trim(sheetname1) + '!' + %trim(cellname) + '+' +
       %trim(sheetname2) + '!' + %trim(cellname) + '+' +
       %trim(sheetname3) + '!' + %trim(cellname) + '+' +
       %trim(sheetname4) + '!' + %trim(cellname) +
  ')';

hth,
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
pdow@xxxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxxx> /

DLee@xxxxxxxx wrote:
JK;

Got it finally.

This is what I changed.

I took this,
somestr = +
  '(' + %trim(sheetname1) + '!' + %trim(cellname) + '+' +
        %trim(sheetname2) + '!' + %trim(cellname) + '+' +
        %trim(sheetname3) + '!' + %trim(cellname) + '+' +
        %trim(sheetname4) + '!' + %trim(cellname) +
   ')';

and changed it to this.

somestr = '(' + %trim(sheetname1) + '!' + %trim(cellname) + '+' +
        %trim(sheetname2) + '!' + %trim(cellname) + '+' +
        %trim(sheetname3) + '!' + %trim(cellname) + '+' +
        %trim(sheetname4) + '!' + %trim(cellname) +
   ')';

And I stopped getting the Operands are not compatible with the type of operator error.

I would have thought the original one would work, but maybe their was an invisible char there since I cut and pasted it into my code.

Much thanks to you and scott.  I really appreciate your patience.

This is the first time I have used this site for problems I'm having,
I'll be watching for you

Later.

Darrell


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.