Window Display Problem - More Info (AREV Specific) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
[[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]]


==== Window Display Problem - More Info (AREV Specific) ====
=== At 05 JUL 2000 02:46:23PM Matt Sorrell wrote: ===
 
{{tag>"AREV Specific"}}
 
<QUOTE>
Here is some more information about my window display problem.



I figured that it was an issue with the current window I was working with, so I started a brand-new window.



I have also reduced my problem set to try and find what the issue is.  In my table DIR_PAY, I have a symbolic field that looks back to EMP and pulls out STATUS_DATES.  STATUS_DATES is an MV column.  The symbolic in DIR_PAY is simplicity:  @ANS=XLATE("EMP", @ID, "STATUS_DATES", "X")



Both tables are keyed with the same value.  I have the column in both tables flagged as MV.  When I created my new window, I placed three fields on the window; Employee No, Name, and Status Dates.  I made status dates an MV field, with about 8 levels of depth.  I did not set the Multi-Value attribute for the prompt.  When I run the window, the Status Dates information is repeated as many times as necessary to fill the depth of the prompt.  If I made the prompt part of an AMV group, the only member of the AMV group, then the data is not replicated in the prompt.  However, after the cursor cycles through the prompts, the second value in the dates prompt disappears.  It is always the second value.



I then decided to go directly to the employee table.  I created a new window, tied it to the EMP table and added Employee No, Name and Status Dates prompts to the window.  None of these fields are symbolics.  All data was displayed and re-displayed correctly.  I then created a symbolic in the EMP table that did exactly the same thing as the symbolic in the DIR_PAY table.  To my EMP window I added the new symbolic column in addition to the data column.  The data column continued to display data correctly whereas the symbolic column demonstrated the same quirks.



In short, it appears that a symbolic XLATE to an MV data column is not displaying correctly in the window.



I am completely at the end of my patience with this and have no idea what I might be doing wrong, if I'm even doing anything wrong.



If any one has any ideas at all, I would appreciate it.



Thanks,

msorrel@greyhound.com
</QUOTE>
----

=== At 05 JUL 2000 03:33PM Don Miller - C3 Inc. wrote:  ===

<QUOTE>Matt ..

The problem is the way symbolic MV's are displayed in the window.  I usually code my symbolic that has to run both in reports and windows like this:

IF @MV THEN

   XX=XLATE("FILENAME",@RECORD,FNUM,'X') ;* ONLY 1 VALUE

   @ANS=XX

END ELSE

   @ANS=XLATE("FILENAME",@RECORD,FNUM,'X')

END

This usually works ..

Don Miller

C3 Inc.

</QUOTE>

----

=== At 05 JUL 2000 05:43PM Matt Sorrell wrote:  ===

<QUOTE>Don,



Thanks for the help.



This is what I finally got to work both on the window and from a TCL.



@ANS=XLATE("EMP", @ID, "EMP_STATUS_DATES", "X")



Again, thanks for the help!!!



msorrel@greyhound.com

</QUOTE>

----

=== At 05 JUL 2000 06:24PM Steve Smith wrote:  ===

<QUOTE>Matt,



FWIW, if you write your own OPEN and READ logic, instead of using XLATE, that the results are faster (even though the symbolics are messier).



steve@state-of-the-art.com.au

</QUOTE>


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