Run a form with predefined key

Tomas

I have a custom form with a button on it. When I click a button, I want to open Item List form, where data is sorted according to Seach Code.

I would imagine this code should solve my question:

Item.RESET;
Item.SETCURRENTKEY("Search Code");

ItemListForm.SETTABLEVIEW(Item);
ItemListForm.RUN;

However, this only works if SourceTableView is not defined. If there is a key defined in SourceTableView property, then this code is useless. Is there any other way of defining a sorting key and forcing it over a predefined key on SourceTableView property?

Thanks for ideas!

i4tost

Create procedure within this form and by using it store global variable value. Then in triger OnOpenForm change the key
Hope its clear

rrvanzyl

Hi Tomas,

I quickly did the following;

1. Added a new button to a form and added the following to the OnPush trigger:
OnPush
Local Var: Item Record: Table 27 Item
Local Var: ItemList Form: Form 31 Item List

//Code...
Item.SETCURRENTKEY("Search Description");

CLEAR(ItemList);
ItemList.SetKey(Item);
ItemList.RUNMODAL;

2. On the Item List form I added the following function: SetKey and a Global Variable GlobItem

3. The SetKey function looks like this...
Setkey(VAR pItem : Record Item)
//Code...
GlobItem.SetView(pItem.GetView);

4. On the OnOpen trigger add the following code
OnOpen
IF GlobItem.CURRENTKEY <> CURRENTKEY THEN
SETVIEW(GlobItem.GETVIEW);

I hope this helps ;-)

Cheers,
R

ritesh.singh

I tried this and it works...

Item.RESET;
Item.SETCURRENTKEY("Search Description");
IF Item.FINDFIRST THEN
ItemList.SETTABLEVIEW(Item);
ItemList.RUN;

Tomas

ritesh.singh wrote:

I tried this and it works...

Item.RESET;
Item.SETCURRENTKEY("Search Description");
IF Item.FINDFIRST THEN
ItemList.SETTABLEVIEW(Item);
ItemList.RUN;

This works ONLY when we do not have SourceTableView property defined to something like SORTING(No.).

Tomas

i4tost wrote:

Create procedure within this form and by using it store global variable value. Then in triger OnOpenForm change the key
Hope its clear

Thanks (ačiū), that is the way I went forward.

DenSter

Tomas wrote:

ačiū

Gesundheit

<edit>corrected spelling, with my apologies to all the German speaking peoples of the world </edit>

garak

DenSter wrote:

Tomas wrote:

ačiū

Gesuntheit

Daniel, Gesundheit you must write with an "d" not with an "t"
@Thomas: Gesundheit (Bless you)

themave

Tomas wrote:

I have a custom form with a button on it. When I click a button, I want to open Item List form, where data is sorted according to Seach Code.

I would imagine this code should solve my question:

Item.RESET;
Item.SETCURRENTKEY("Search Code");

ItemListForm.SETTABLEVIEW(Item);
ItemListForm.RUN;

However, this only works if SourceTableView is not defined. If there is a key defined in SourceTableView property, then this code is useless. Is there any other way of defining a sorting key and forcing it over a predefined key on SourceTableView property?

Thanks for ideas!

This may be a dumb question, but this is your custom form, you want it to sort this special way, then why are you setting the SoruceTableView in the first place, why not just use the code suggested, and not define the SoruceTableView on the form ?