Here's the deal. I do the following code on my NT box against an DB2 database and this fails. If I push this up to the os/390 environment, it works. I tracked it down to be this. If I retrieve the same piece of information from the record set twice, it fails on NT.. but works on the os/390. I have a work around... I already have that solved.. my question is WHY would this happen.
Regards, Dale DeMott ------------------ By failing to prepare, you are preparing to fail. Benjamin Franklin (1706 - 1790)
By failing to prepare, you are preparing to fail.<br />Benjamin Franklin (1706 - 1790)
Looks like "one of those driver things". As a basic rule, no, you can't read the same thing twice so you have to read it and store it in a variable then use the variable twice. Dave.
The ResultSet interface provides getXXX methods for retrieving column values from the current row. Values can be retrieved using either the index number of the column or the name of the column. In general, using the column index will be more efficient. Columns are numbered from 1. For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once.
You should definitely be able to read left-to right once. Anything else depends on your driver.