| Order by the control block data using oracle 10g form [message #581877] |
Thu, 11 April 2013 09:00  |
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
|
Senior Member |
|
|
I have two block....both are the control block..
in first block i select the date and in second block the data of that date is populated.but the data is populated
using cursor in when-button-pressed trigger of that first block button...
in cursor the data is selected and placed in field of detail block using into clause.... each field..
.and one item of detail block is srno which is create in post-query of detail block using
:sysyem.trigger_record.
Now i want after populated the detail block the data is sorted desc one of the field of the detail block...
Can this possible using set_block_property() of block although the block is control block if yes where i should do
this??????
Please explian...????
|
|
|
|
|
|
| Re: Order by the control block data using oracle 10g form [message #581879 is a reply to message #581878] |
Thu, 11 April 2013 09:22  |
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
|
Senior Member |
|
|
but with the cursor of repopulate ...how the block is in desc by one field..because if i use again the same cursor to poulate than whats this benefits???
if i write a cursor in button when-button-trigger in first block like this code....
go_block('');
cursor emp_cur is
select empno,date,sal
from emp;
begin
for i in cur loop
select i.empno,i.date,i.sal
into :empno,:date,:sal
from emp
end loop
end;
this loop populate the block which is controll block..
syntax error should be ignored ...i wana to explain what i want to do...
this is not the actual query i have another query but the concept is that...
how i can do this...
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
