Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Forms Personalization on Shipping form

244101Feb 27 2007 — edited Mar 1 2007
Hi
I use Forms Personalization on the shipping form WSHFSTRX, to split a line. Once done, the new delivery (:dlvb.delivery_name) and the line (:dlvb.detail_label) do get created and placed as last record of the block. After the split, I do execute_query. But before execute_query, I tried to set order by clause on delivery and line descending but wasn't successful. I wanted the split line and delivery to be shown as the first records in the view after the excute query within forms personalization.
Another way was to issue a LAST_RECORD built-in. But this does not seem to be an option for built-in in type DO_KEY. Can anybody suggest a means of how I can implement that the records queried after the split are ordered by detail_name in descending order or move the focus of the cursor to the last record in the block after querying.
One other way was to use scroll_down builtin which is available to do_key builtin type in forms personalizatiomn. But this would only scroll once to the last set of the view which is not the functionality I wanted. Any suggestions is highly appreciated.
Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 29 2007
Added on Feb 27 2007
3 comments
1,690 views