[[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]]


==== Popups - values from (a) columns in (a) specific rows (AREV Specific) ====
=== At 22 APR 2000 01:58:44PM Dale Walker wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Ok, I give up. I checked the documentation, The online help in arev, the search on the website, and I found no answer. I don't really want to bug youse guys but I need some help.



It is my desire to create a popup wherein I can call a specific row from a table and make a selection from (a) multi-valued column(s).



The rows have to be based on the information in the previous multi-valued column.



Your assistance will be greatly appreciated.



Dale
</QUOTE>
----

=== At 22 APR 2000 03:23PM Chris Leenhouts wrote:  ===

<QUOTE>Here are 2 ways to create a popup that allows the user to select a multi-value line from a table row. They both require that you predefine a record mode popup and write code to populate the lines you wish to display (see below). The value of @ANS is the value number the user has selected;



1) Quick-and-dirty; Write the multi-valued fields directly to the POPUP record you have previous identified (see below). This is quick to write, but not to execute and can cause problems in a multi-user environment.



2) Use the POPUP_SOFT utility, asumming you are running AREV 3x, which will allow you to show the popup record without writing to the file. You still need to build the popup rows like below.



Sample Code;



             OPEN '','POPUPS' TO POPUPS THEN

                 READ POP.REC FROM POPUPS,'MYPOPUP' ELSE

                     CALL XABORT('UNABLE TO READ MYPOPUP FROM POPUPS')

                     RETURN

                 END

                 POP.REC=MYNAME:' CUSTOM TITLE'

                 POP.REC='

                 EOF='

                 LOOP UNTIL DONE

                 *** ADD FIELD DERIVATIONS TO TASTE

                             POP.LINE=FIELD1:"|":FIELD2:"|":FIELD3

                             POP.REC=POP.LINE

                 REPEAT

                 WRITE POP.REC TO POPUPS,'MYPOPUP'

                 @ANS='

                 CALL CATALYST('P','POPUPS*MYPOPUP')

</QUOTE>

----

=== At 22 APR 2000 04:35PM Dale Walker wrote:  ===

<QUOTE>I appreciate your quick response. I am using 3.12. Tell me more about the POPUP_SOFT utility.



Thanks,

Dale

</QUOTE>

----

=== At 23 APR 2000 05:10PM Chris Leenhouts wrote:  ===

<QUOTE>I found Popup_soft in the Technical Developer's guide for AREV and used it extensively for one project. Unfortunately I won't have access to the guide nor the application for a few weeks. I'll give you the lowdown then. In the meantime, use the code I gave you, it's only a minor adjustment thereafter.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=77A9D8D4DF896472852568C90062C31A|View this thread on the  forum...]]