| order by in tabular form [message #234340] |
Mon, 30 April 2007 23:58  |
manyal
Messages: 84
Registered: March 2005
|
Member |
|
|
Dear Friends,
I am using forms 6i and i have made one tabular form but my problem is this i want the data block to be populated in the order of one of the display item, which is not a database item.
that display item has been derived after joining the base table with another table.
Thanx in advance.
Manish Manyal
|
|
|
|
|
|
|
|
| Re: order by in tabular form [message #234786 is a reply to message #234340] |
Thu, 03 May 2007 03:10  |
sameer_am2002
Messages: 129
Registered: September 2002
|
Senior Member |
|
|
Hope if this can help you.
Test Case
Create a View Emp_V as
select e.empno , e.sal , e.deptno , d.dname , e.hiredate , e.comm from emp e , dept d where e.deptno = d.deptno
Base your Block's Query Source on this View
Set the property of Dname QueryOnly to yes
Now Set the Block Property DML Target Type as Table
and DML Target Name Emp
So what we are doing basically we are querying through View but manipulation is directly on the table.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
