I have a popup defined as follows:

Source:     Cursor of Table Rows

Selection:  Person Table (id, name, and address fields), Cursor 0

Value:      Value Returned is Row ID, selection is single

Options:    All selected

I have a form "person" which calls a subroutine from a quick event to search for a persons name. It is as follows (SEARCH_STRING is currently hard-coded):

SUBROUTINE SELECT_BTREE(FILE,SEARCH_STRING)

DECLARE SUBROUTINE MAKE.LIST

DECLARE FUNCTION POPUP, SORTPERSON

OPEN "DICT.":FILE TO DICTVAR THEN

END

CALL BTREE.EXTRACT(SEARCH_STRING, FILE, DICTVAR, KEYS)

IF KEYS THEN

  Open FILE to tablehandle Then

end

Make.List (0,KEYS, tablehandle, DICTVAR)

selected=popup(@window,"","pop_up_person")

END

I run it in debug mode and "KEYS" has 4 different keys but when the popup is displayed only the first key is displayed.

My other problem is that when I select the record from the popup, I want it to put the record id into the text value of my "id" field on the form. I have the quick event control set to my form and "id" field and the poperty set to "text". When selecting the value from the popup, whatever was in the "id" field on the form is blanked out.

Thanks as always for the help.

- Greg

You need to change @Vm to @Fm in your hits before make-listing and I don't understand your second question.

[email protected]

Sprezzatura Ltd

World Leaders in all things RevSoft

Greg,

For your first question, do what Andrew suggested.

For your second question, the problem is that you are mixing your methods here. If you are programmatically launching a PopUp, then you must programmatically set the TEXT property of your key with the select value. QuickEvents will only work if you are using the QuickEvent to launch the PopUp for you.

[email protected]

SRP Computer Solutions

Thanks for that info guys. I got my pop-up to display all of the records. As for my second problem, when I select the record from the pop-up, the pop-up closes and control returns to the subroutine that called the pop-up. Now how do I read what the selected value was? This is probably an easy one as well but I'm finding this product quite difficult to learn. Thanks again.

Oops. Please disregard that last post. The popup obviously returns the selected record id back to the caller. What can I say.. it's late… must sleep…

View this thread on the forum...