Datawindow SQL Select not returning all rows. PB11.5

[LunaRoja]

Hello,

I am using a datawindow (for experimentation) with an embedded select of three values (sql is below - Oracle 10g). I am just forcing three rows into the datawindow. But, I never get the third row. And, if I modify the select to ONLY contain a select of that last row, the select returns the previous two rows, as though it is remembering the old select. I have regenerated, reset and a number of other things. I think this is a simple issue, but I have been away from PB for years and I am not seeing the solution. The select returns three rows in the datawindow preview and when I run it independently in Oracle.

I would appreciate any ideas. I am spinning my wheels at this point. The select seems simple and there is nothing complex going on inside the code... just a straight-forward retrieve.

Thanks... LR..

/////////// Datawindow SQL //////////////
SELECT 'vessel_bkg_cmnt' as col_name,
0 as xposit,
0 as yposit,
0 as widandxpos,
0 as hgtandypos,
'Vessel Booking Comment' as col_desc,
'This is an example of popping up the Booking Comment value.' as hist_value
FROM DUAL
UNION ALL
SELECT 'reason_for_change',
0,
0,
0,
0,
'Reason For Change',
'This is an example of popping up the Reason For Change value.' as hist_value
FROM DUAL
UNION ALL
SELECT 'place_of_receipt',
0,
0,
0,
0,
'Place of receipt',
'This is an example of popping up the Place Of Receipt value.'
FROM DUAL
////////////////////////

 

[mbalent]

Just to make sure...

Open the datawindow object, go to Rows - Filter

Make sure there isn't a filter which may be excluding the row.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[LunaRoja]

Thanks for the suggestion, but no filter was in place. I cannot figure how PB was caching the results. I finally put the data in a table and rebuilt the datawindow and got the results I neeed.

Thanks again,

LR

 

[doinaclaudia]

If you get your select into Toad and past it you will see that the return carriage is not there!
Try to format it properly test in in oracle then use it after yo ucorrect it

-- here is what you i meant!!! the
SELECT 'vessel_bkg_cmnt' as col_name, 0 as xposit, 0 as yposit, 0 as widandxpos, 0 as hgtandypos, 'Vessel Booking Comment' as col_desc, 'This is an example of popping up the Booking Comment value.' as hist_valueFROM DUALUNION ALLSELECT 'reason_for_change', 0, 0, 0, 0, 'Reason For Change', 'This is an example of popping up the Reason For Change value.' as hist_valueFROM DUALUNION ALLSELECT 'place_of_receipt', 0, 0, 0, 0, 'Place of receipt', 'This is an example of popping up the Place Of Receipt value.'FROM DUAL

 

[LunaRoja]

Thank you for looking into this and setting me on the right course.

I appreciate it,

LR