| How to handle (supress) ROWID in Forms [message #85350] |
Thu, 17 June 2004 21:39 |
Ravindra
Messages: 11
Registered: January 2002
|
Junior Member |
|
|
The Scenario is...
In a Form (LOV Form that is called from another Form using CALLFORM), For a particular Data
Block(TABLE 1)....
In the Block properties ..under Database section, I have given the 'WHERE Clause' like this..
column IN (Select.....subquery....)
UNION ALL
select ROWID,C,D from TABLE2
where column IN (Select.....subquery....)
and <....some expression...>
Forms will replace this internally like this
<<< select ROWID,A,B from TABLE 1 where >>>
column IN (Select.....subquery....)
UNION ALL
select ROWID,C,D from TABLE 2
where column IN (Select.....subquery....)
and <....some expression...>
TABLE 1(Transaction Table) is a Data Block in a Form whereas TABLE 2(History Table) is not a Data Block in this Form.
In the query after UNION ALL if I dont give ROWID, then Form at runtime throws the following error
Unable to perform query.. ERROR Displayed is ...
ORA-01789: query block has incorrect number of result columns
Now the Problem is..............
The above query in normal case gives/populates say some 500 records..
with ROWID in the query, it is duplicating on Columns A and C.. and giving/populating some 15000
records.. which is time consuming..
Is there any way to supress the ROWID in the forms..
Forms adds ROWID by default...
What is the Fix or other possible Solutions for the above problem..
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
