Home » Developer & Programmer » Forms » order by in tabular form
order by in tabular form [message #234340] Mon, 30 April 2007 23:58 Go to next message
manyal
Messages: 77
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 #234369 is a reply to message #234340] Tue, 01 May 2007 03:46 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, you could create a view which would contain that "additional" column and base a block on the view.
Re: order by in tabular form [message #234698 is a reply to message #234369] Wed, 02 May 2007 23:07 Go to previous messageGo to next message
manyal
Messages: 77
Registered: March 2005
Member
Dear littlefoot,

But in that case view wud not be updateble as i want to update the data also . please tell me another alternative.


Manyal
Re: order by in tabular form [message #234786 is a reply to message #234340] Thu, 03 May 2007 03:10 Go to previous message
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.
Previous Topic: Validation of multirecord block
Next Topic: Text item
Goto Forum:
  


Current Time: Fri Dec 09 15:33:12 CST 2016

Total time taken to generate the page: 0.15866 seconds