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,

[email protected]

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.

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!!!

[email protected]

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).

[email protected]

View this thread on the forum...