Re: Running into a problem with JDBCR4 expansion

On 7/5/13 6:15 PM, Gary L Peskin wrote:

Are you missing the

rs.beforeFirst();

after the dsply statement?

Uh, no, at least in theory, the DSPLY statement *is* the call to rs.beforeFirst(), displaying the result. To wit:

beforeFirst() is exposed in the service program thusly:

D b4FirstRec...
D PR 1N ExtProc(*JAVA:
D 'java.sql.ResultSet':
D 'beforeFirst')

and given this wrapper, again in the service program:

P JDBC_B41stRow B export
D JDBC_B41stRow PI 1N
D rs like(ResultSet)
/free
monitor;
return B4FirstRec(rs);
on-error;
return *OFF;
endmon;
/end-free
P E

which is then called from the test program:

dsply jdbc_b41stRow(rs);

Yet it doesn't appear to work.

--
JHHL