SQL Report Shows Incorrect Value For One Column
473557May 2 2008 — edited May 3 2008Hello, I'm working with HTMLDB Version 1.5.0.00.33, and have a problem with display data in a report region.
The region in question uses a SQL query to generate the report data. For each row in the report, the values for one column of the report are displayed with an incorrect value. This value is the same for every row in the report. The column in question is not being transformed by my query in any way -- it's just displayed with a wrong value.
Running the SQL Query in a SQL*Plus session yields the correct results, so I know the data in the table is correct and the query is correct.
I've done some experimentation, and found that by simply querying out the column a second time in the same query, I get the correct values displayed in BOTH columns.
I've been unable to find any bug reports or TAR's about this -- does anyone have any ideas how this might be happening? Unfortunately, the application code is in a DoD facility and cannot be provided.
Thanks in advance.