[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]
==== Popup list issue (AREV Specific) ====
=== At 22 MAR 2000 12:17:49PM Dale Walker wrote: ===
{{tag>"AREV Specific"}}
I have an application that I was running in Arev 2.03. I encountered a problem that I hope was cured in 3.12. It wasn't. I have a entry screen that has indexed fields and popup fields that retrieve information. These fields retrieve a list from the lists table.
When I arrow to a field/column or use the key, the list is acquired from the list table. F2 gives me access to the list in alphabetic order and I am able to make my selection and go on my way.
However, If I use the index feature at the key field/column, and look for a name and select from the list returned , F9 I get the record but when I tab to the field(s) with the popup, the list returned is not in alphabetic order. and the problem persists until I exit AREV and restart.
Is this a bug or have I set up the window incorrectly?
TIA
Dale
----
=== At 22 MAR 2000 01:59PM Bill wrote: ===
Dale,
What is the mode of the popups you are using: (T)able, (R)ow or (C)olumn? Is the popup called as a prompt process directly? Or is it a CATALYST call from an R/Basic program?
Bill
----
=== At 22 MAR 2000 03:55PM Dale Walker wrote: ===
It is called from a window not a catalyst call in a R/BASIC program.
It is defined in the Prompt definition window. code p : command popups*city
Dale
----
=== At 22 MAR 2000 10:44PM Bill wrote: ===
Dale,
Using a customer window, I built 3 different versions of a ZIPCODE popup. One using table mode for the ZIPCODE file with and without Quickdex installed; one using row mode accessing a sorted LIST of ZIPCODES; and one using column mode with the sorted multivalue ZIPCODES LIST in field 1. I placed the P | POPUPS*ZIPCODE code and command in the prompt options.
After using the Browse Cross Ref. option on the key field and retrieving a record, I moved to the zipcode field and pressed . The only time I did not get a sorted list was when Quickdex was removed from the zipcodes file. I also tried retrieving records using Query ("\" at the key prompt) but it made no difference.
If this is basically the process you have followed, I have no easy solution to offer. I can't replicate the problem.
Bill
----
=== At 23 MAR 2000 01:48PM Dale Walker wrote: ===
I'll setup quickdex on the city_list_dat file. Hopefully this will solve the problem.
Dale
----
=== At 24 MAR 2000 08:58AM Dale Walker wrote: ===
I reinstalled the quickdex on my city_list_dat file. 3272 entries.
Now instead of getting random entries, I now get a list of communities that are shown in roughly the order in which they were created if I select an entry in the ind_data file screen. 1,10,100,1000,1001,...
If I go to the field with the popup and press f2 then all the communities are in alphabetic order (field 1) if I do not use the index selection.
I need to have Aberdeen, Power, ID show up on the first page of the popup and not Salt Lake City, Salt Lake, UT (1) in all cases.
My question is: Does arev use the same memory for popups as does the index selection? If so, is it refreshed?
Dale
----
=== At 24 MAR 2000 12:30PM Warren wrote: ===
I'm rusty on this stuff but as I recall depending on the mode POPUP will uses the active select list.
There is also a way to embed a sort/select statement into the template, again depending on the type/mode of the popup - I don't recall the details on this one - the Sprezz or Revelation krewes can answer this one.
However in your routine you can do a sort select for your records, call the popup, store the result in memory. If the file is indexed you can do a btree.extract, add the constant keys to the key list, make.list and call the popup. You may have to do a push/pop.session to protect your main @variables for windows.
----
=== At 24 MAR 2000 12:37PM Bill Titus wrote: ===
Dale,
Okay. Let's go after this problem step-by-step.
Your Quickex on the "city" file is using the dictionary-defined left justified numeric id. So they are ordered 1, 10, 100, 1000, 1001, etc. You'll need to remove Quickdex, change the id justification to "right" and then install Quickdex again for 1,2,3,4,... sorting. But I'm not sure that gets us anywhere.
Quickdexing works on the ids of the records, not their contents. So you would never get a popup of the city information in alphasort order using Quickdex, unless record 1 was for Aardvark City and 3272 was for Zymergytown.
I think what's happening is that an active select list produced during your lookup process is not being cleared before the city popup is called, and it's still active when the popup is called. I'd be especially suspicious if both files use purely numeric ids.
Do a lookup - the one that eventually causes the problem - and write down the first 4-5 record ids. Then go to the field where you call the popup and call it. Compare the lookup ids written down to the id order of the items in the popup. This assumes ids appear in popup. If not, you might want to amend the display so they do just for this test.
Let me know what you find.
Bill
----
=== At 24 MAR 2000 02:04PM Bill Titus wrote: ===
Dale,
You could also use this for the prompt "Options" code and command (copied from Paint help):
V file,index{,code}
(Value lookup). Use the V popup when you want to display a popup
of values for a field that has been indexed. The user can choose
one or more values from this popup.
Note: By default the popup is single selection. To specify a multiple selection popup, include the code M in the command. A multiple selection popup should only be used at a prompt that is multivalued and that is not the key.
Example: PRODUCT,PRODUCT.NAME,M
Don't use it myself, so hadn't thought of it before.
Bill
----
=== At 25 MAR 2000 10:52AM Dale Walker wrote: ===
I do have the id's show up for both files. IND_DATA (personal data records) and CITY_LIST_DAT (Names of Communities).
At the Key prompt, I press and get a list of indexed fields. I select my record on the Fathers_no prompt 21310, F9, And see all ten of my kids, (brag, brag), select my first child 21321, , and her record comes up. I key to the place of birth field and press , and I get a list of communities in neither alphabetic order or @id order.
The @id's for the kids are 21321, 21327, 21333, 21339,.... The @ids for the communities are 47,95,105,194... consistently.
If I do not do an index selection for individuals, the community list is alphabetic.
Dale
ps. there are over 77800 records in the IND_DATA file.
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=8730C73A13EB2335852568AA005985CA|View this thread on the forum...]]