{{tag>category:"OpenInsight 32-Bit" author:"Warren Auyong" author:"Sean FitzSimons"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== POPUP column(s) from Row (OpenInsight 32-Bit) ====
=== At 14 FEB 2006 04:28:24PM Warren Auyong wrote: ===
 
 
<QUOTE>
V7.21



UI Workspace I designed a popup: 

source "Column from a Row"

Selection - Table - Row ID & Column (DEFAULT, 1) no quotes (record "DEFAULT" has been created in file in question)

Layout - 1,heading,'',20,L,C

Options - defaults



When I run the popup in test mode, no popup is displayed and I get the message "No value returned ". Tried it from a stored procedure called from a form via popup function too - no popup.



I tried putting the record id and the column in double quotes, {}, single quotes - nothing. Also tried the dict item name instead of column number in quotes and {} - nothing



What am I doing wrong or is popup broken?
</QUOTE>
----

=== At 15 FEB 2006 02:08PM Warren Auyong wrote:  ===

<QUOTE>I tried this in v7.11 also. No dice.



Back to v7.21 I tried overriding the mode via the popup function. No dice either. The popup will not display.

</QUOTE>

----

=== At 15 FEB 2006 04:22PM Sean FitzSimons wrote:  ===

<QUOTE>Warren,



I have not fully dived into the problem but I did duplicate your results.  Please stay tuned for more info from me.



Thanks,

Sean

</QUOTE>

----

=== At 16 FEB 2006 08:43AM Sean FitzSimons wrote:  ===

<QUOTE>Warren,



[i]I tried putting the record id and the column in double quotes, {}, single quotes - nothing. Also tried the dict item name instead of column number in quotes and {} - nothing[/i]



The record id should be just the id, no quotes, no {}, just the ID.

The layout page is most likely the cause of the behaviour.  If there is an extra row in the layout table, I can repeat your behaviour.  I deleted the extra row and all was fine.  I did this in 7.1.1 also and received the same results.



Sean

</QUOTE>

----

=== At 16 FEB 2006 12:38PM Warren Auyong wrote:  ===

<QUOTE>Great. As a work around for now I'm building the list from an xlate and using a Mode "L" popup. It means having to call a pre-processor but it works. I need to call a pre-process regardless as the Row ID can change related to context.

</QUOTE>


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