Thank you again for replying, Rehan. Yes, vResponse is the assigned variable...but in the code given it produces a null. It does NOT contain the CustID of the record selected in the lookup listing.
Bear in mind that I am using the documentation's example for the DIALOG LOOKUP command. And that this extended code does more than merely collect a text string. First, it asks for a text string. If the user instead double-clicks, it then shows a list of possible choices -- an actual popup. Select one, and you return to the first box asking for a text string. ONLY IF TEXT IS ENTERED HERE does vResponse contain a value. So...what value is a lookup then? Or, how to make use of it. dbl click & get this In selecting a customer or a part or any of a mass of possible items, you're most likely going to need to select from a list than type in the full, exact text or number. So, how to get this lookup LIST *and* return a valid value? How can the list be make to appear without the usually unnecessary step of the text box & double-clicking? How can the two methods be made work together (as the poorly documented example intended)? The code below following the example works fine but doesn't return a value from a selection if the popup is activated. DIALOG 'Enter Contact to Edit' vResponse=26 vEndKey 1 CAPTION 'Contact Info' ICON APP OPTION DIALOG_EDIT_HINT 'Double-Click for a List of Contacts' |POPUP_ENABLED TRUE |POPUP_DIALOG_TYPE LOOKUP |POPUP_TITLE_FONT_NAME VERDANA |POPUP_TITLE_FONT_SIZE 10 |POPUP_TITLE_FONT_BOLD TRUE |POPUP_TITLE_FONT_COLOR GREEN |POPUP_TITLE_BACK_COLOR WHITE |POPUP_TITLE_TEXT 'Select Contact to Edit' |POPUP_LIST_FONT_COLOR GREEN |POPUP_LIST_BACK_COLOR WHITE |POPUP_CAPTION 'List of Contacts' |POPUP_TABLE Citizens |POPUP_SELECT Name_F,Name_L, Addr1, Addr2, Email |POPUP_RETURN_COLUMN CitizenID |POPUP_WHERE WHERE Name_L CONTAINS .vResponse OR Name_F CONTAINS .vResponse OR Addr1 CONTAINS .vResponse OR Addr2 CONTAINS .vResponse OR Email CONTAINS .vResponse ORDER BY Name_L, Name_F |POPUP_SHOW_LINES TRUE |POPUP_RETURN_TYPE COLUMN |POPUP_LINES 20 |POPUP_DISTINCT TRUE On Friday, April 29, 2016 at 12:02:48 AM UTC-7, rehan_wyne wrote: > > Michael, > > vResponse is the variable which will hold the returned value > > Rehan Wyne > > > > On Friday, April 29, 2016 10:59 AM, Michael <[email protected] > <javascript:>> wrote: > > > The DIALOG Lookup command appears to do what I would like it to do -- but > the documentation ends without any explanation of how to access the value > selected in a lookup. I see no new variable, or any that appear to hold the > resulting value. It appears to me that the value selected simply disappears > into a black hole. > > I copied the example from the manual/help screen, changed my table & > column names, and it works on screen...just doesn't produce any resulting > value I can find or access. As an example, I'd like the user to examine a > list of customers, select one, and return the primary key value (CustID). > > Using a POPUP_RETURN_COLUMN CustID | POPUP_RETURN_TYPE VALUE, where is the > value of CustID to be found? > > If I instead use POPUP_RETURN_TYPE COLUMN, what info is actually returned? > And where is it to be found? > > > DIALOG 'Enter search string to look for in database' vResponse=25 vEndKey > 1 + CAPTION 'Search' ICON INFO + OPTION > DIALOG_EDIT_HINT 'Double-Click for a List of Contacts' + > |POPUP_ENABLED TRUE + |POPUP_DIALOG_TYPE LOOKUP > + |POPUP_TITLE_FONT_NAME VERDANA + > |POPUP_TITLE_FONT_SIZE 10 + |POPUP_TITLE_FONT_BOLD TRUE > + |POPUP_TITLE_FONT_COLOR GREEN + > |POPUP_TITLE_BACK_COLOR WHITE + |POPUP_TITLE_TEXT 'Select > Contact to Edit' + |POPUP_LIST_FONT_COLOR GREEN > + |POPUP_LIST_BACK_COLOR WHITE + |POPUP_CAPTION > 'List of Citizens' + |POPUP_TABLE Citizens + > |POPUP_SELECT Name_F,Name_L, Addr1, Addr2, Email + > |POPUP_RETURN_COLUMN CitizenID + |POPUP_WHERE ORDER BY > Name_L, Name_F + |POPUP_SHOW_LINES TRUE + > |POPUP_RETURN_TYPE COLUMN + |POPUP_LINES 20 + > |POPUP_DISTINCT TRUE > (manual's example adapted to my data). > > Thanks for any guidance. > -- > You received this message because you are subscribed to the Google Groups > "RBASE-L" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] <javascript:>. > For more options, visit https://groups.google.com/d/optout. > > > -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
