Re: Update a spreadsheet with data from iSeries (II) -- RPG400-L

Hereafter all the records are updated from row 2 to 109 in the sheet,
with the following line:
Row = HSSFSheet_getRow(Sheet: RowCount) - (RowCount=10i  0)

I don't understand what this line of code does. You can't subtract fromthe value of "Row", it's a Java object reference, not a number.

When record no. 108 (the last record) is updated Row has a value of 0
(zero) and RowCount a value og 109 - and the program dumps.

If Row contains 0, it means that HSSFSheet_getRow() has failed. Insert acheck that says


    if row = *null;
       HSSFSheet_createRow()
    endif;

(just like we discussed in a different thread.)

I know why.... (calculating: 56.616 + 534= 57.150) because of an integer
overflow in HSSFRow (jInt)

jInt can store numbers up to 2147483647. 57150 would not even come closeto overflowing it. If it's a jShort, then it would overflow at 32767. So,I don't see why you'd get an integer overflow.

Any hints for using a double Integer (jDouble) in HSSFSheet_getRow() or
another method ???

jDouble is floating point (8F in RPG) not integer. It can store extremelylarge numbers (much higher than the integer numbers)

This mailing list archive is Copyright 1997-2026 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.