Popup size (OpenInsight Specific) [Revelation On-Line Wiki]

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

At 26 NOV 2001 02:24:42PM a becker wrote:

OpenInsight Specific

Have a strange problem. I have created a table, the key is varchar. When I use this in a popup, the key field changes to numeric on the popup and will display approxmately 6 characters. I can manually resize the column to display all the key field, but why should the user have to do that?

Why is the key field changing to numeric and how can I overcome this problem?

At 26 NOV 2001 03:36PM Richard Hunt wrote:

I just created a table with the key being VARCHAR(65531). Created a popup using the User Interface.
 Source: Select rows from table.
 Selection: The created file with the key, f1, f2, and f3.
 Layout: Defaulted with the info from the file's dictionary.
 Value: Popup Column 1 (the key).
I ran the popup from the User Interface, it worked fine. The key column remained the correct size.

I ran the popup from a window, in the create event.
 RESULT=POPUP(WINDOW,NOTHING,POPUP_NAME)
It worked fine too.

Hmmmmm… just thought I would let you know.

At 26 NOV 2001 04:56PM Robert Lee wrote:

Was the key originally numeric? Have you changed it or was it always VARCHAR. What is the dictionary length for that field? Is there any conversion on it? What happens if you delete the popup and create it from scratch?

A few diagnostic questions … and by the way how's your blood pressure? :)

Robert Lee

At 27 NOV 2001 12:31AM Donald Bakke wrote:

…the key field changes to numeric on the popup…

What exactly do you mean by this? Are the characters displaying differently? Is this a right justified versus left justified issue?

…and will display approxmately 6 characters.

You mean based on the width value in the Popup Layout definition?

I can manually resize the column to display all the key field, but why should the user have to do that?

If you are the programmer and you preset the column width correctly, why would the user be involved at all? Were you expecting the Popup to utilize the dictionary settings automatically? AFAIK you always have to explicitly define how the data should display in each column of a Popup.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

At 27 NOV 2001 09:40AM a becker wrote:

Thanks for all your input. Robert Lee gave me the clue that solved it. He asked if the key was ever defined as numeric and then changed to varchar. After thinking about it, I thought that maybe that was the case. I cleared the data and reentered some records and sure enough, the problem was resolved.

Again thanks for all your help.

Andy Becker

Illinois State Lottery

View this thread on the forum...