Home » Developer & Programmer » Forms » GO_RECORD ?
GO_RECORD ? [message #247430] Mon, 25 June 2007 21:07 Go to next message
Felc
Messages: 1
Registered: June 2007
Junior Member
Hi all experts,

I am trying to bring the record to the first row of the form.

For example I have a form with display from A to Z.

Say if "E" is the one I am interested with, what sort of command should i be using to bring "E" to the first row?

I was using GO_RECORD(1) and it didn't work for me as the form kept on showing "A" as the first row.

Can somebody please help ?

Many thanks
Re: GO_RECORD ? [message #247503 is a reply to message #247430] Tue, 26 June 2007 02:50 Go to previous messageGo to next message
hemavb
Messages: 103
Registered: May 2007
Location: Dubai , UAE
Senior Member
GO_RECORD(n) will NOT MOVE the record, it will just move the Cursor to the record number provided to it.

You cannot move a record. There is a work around way but will take some programming to do.

Here is what is possible.
Assumed Block Name: DATA
1) Keep one more column in your table name it SORT_ORDER. Now in this column you will store the preference ranking. The once which you want on the top will be 1, then 2 then 3 and so on.
Add this column/field to your DATA block in the form. Keep it a hidden column, i.e., physical property > visible > no.

2) In the Block put SORT_ORDER in the order clause of the Block.

3) Add a POST-QUERY trigger to the block level. Use the following code in this trigger.
:SORT_ORDER := NVL(:SORT_ORDER, (:SYSTEM.TRIGGER_RECORD - 1)) + 1;


4) Use a push button to set preference to a record. In that push button's WHEN-BUTTON-PRESSED trigger write the following code:
:SORT_ORDER := 0;
POST;
GO_BLOCK('DATA')
CLEAR_BLOCK(no_validate);
EXECUTE_QUERY(no_Validate);
FIRST_RECORD;


This should give you your desired result.
Restrictions:
a) It will work only with a block which has a source. It you are using a cursor to populate it will not work. or you may have to modify it a little to work.
b) If there is lot of data/no indexing on your base table, it will be a lil slow.

Its a long shot but gets the work done. Till no other fix is given by one of the geniuses on this forum, use this.

Hemavb
Re: GO_RECORD ? [message #252511 is a reply to message #247430] Thu, 19 July 2007 01:23 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
@Felicia,

Are you happy with this solution?

David
Re: GO_RECORD ? [message #252568 is a reply to message #247430] Thu, 19 July 2007 03:23 Go to previous message
zameersait
Messages: 16
Registered: July 2007
Junior Member
If u want to order the block by any column then use the Order By property of the block. If you are not able to sort the records as you wanted, then add a column in the table to input the soring order and use this column in 'Order By' property of the block.
Previous Topic: Printing reports using 9iAS
Next Topic: how to attach holidays in my discount form in form 6i
Goto Forum:
  


Current Time: Sun Dec 04 16:45:58 CST 2016

Total time taken to generate the page: 0.09209 seconds