OraDeveloper 2.50.101 - Output says "60 records selected" but nothing in Data

OraDeveloper 2.50.101 - Output says "60 records selected" but nothing in Data

Postby benkedon » Tue 11 Sep 2007 18:34

Hi,

Ran the following query :

select t."Incident ID" "Incident", t."WO Number" "WO", t.OPEN_PERIOD||'W'||t.open_week "PdWk", to_char(t."Open Date",'YYYYMMDD')||' '||t.open_time "Open Date",

-- case
-- when t.description like 'Using default%'
-- then replace(replace(t.description,'-------------------------------------------------'),chr(10),' ')
-- else t.description
-- end "Description",
replace(replace(replace(replace(t.description,'-------------------------------------------------',' '),chr(13)||chr(10),' '),chr(13),' '),chr(10),' ') "Description",

t.item_catalog "Item Catalog", t.resolution "Resolution", t.*
from esp_dev.workorder_report t
-- where open_year = '2007' and open_period = 'P04' and open_week = '4' -- and technology = 'ORACLE' (was example where incident had 'ORACLE' technology, but work order had 'UNIX') and
where "Incident ID" in (
select "Incident Number"
from esp_dev.incident_report
where technology = 'ORACLE' and open_year = '2007' and open_period in ('P09') -- and upper(t.description) like '%SAP%' -- and open_week in ('1','2','3','4')
)
order by 5 --"Incident ID", t."WO Number"

-------------------------------------------------------------
"Output | General" window says :

- 2:32:35 PM -
SQL1.sql: Query opened in 23.273 s [0.282 s exec, 22.991 s fetch]
60 records selected

BUT neither the Data View or Data Window have any data in them !?
benkedon
 
Posts: 28
Joined: Tue 15 May 2007 12:27

Postby Alexz » Wed 12 Sep 2007 07:29

We have found the problem and we'll resolve it. The new build will be available in a few days.
Alexz
Devart Team
 
Posts: 165
Joined: Wed 10 Aug 2005 08:30


Return to dbForge for Oracle