Forms Personalization on Shipping form
244101Feb 27 2007 — edited Mar 1 2007Hi
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