Can I "normalize" a popup?

If I have 3 columns in a popup; the first being the key, the second let say name, and the third a multivalued calculated column so that

the out put would be…

1 9999 Smith, Barney 800-555-1212

2 9999 Smith, Barney 888-555-2121

3 9998 Jones, Grace 800-555-0001

4 9997 Rogers, Mr 880-456-7890

5 9997 Rogers, Mr 880-987-4561

of something of this nature?

Bruce,

Is it a predefined popup? What happens if you specify the popup should be sorted by your multi-valued column?

A few years back I struggled a lot with a similar popup. I did succeed, but looking at my solution today I'm afraid I can't tell why!

Anyway - it should be possible to do with a bit of programming.

- Oystein -

This is pretty straightforward if you write your own code to call the popup instead of using the Popup quickevent.

The POPUP function has an override parameter which allows you to put whatever data you like into the popup. So you can write your own code to normalise the data and then pass that as an override parameter.

I don't think it is possible to do what you want using an unmodified popup but some bright person may prove me wrong…

Robert Lee

Oystein and Robert,

Right you are. I don't have a problem with writing any code I wanted to see if there was a quick solution. In 'Pick' you can you can use a correlative function 'R' for 'repeat value'. Just thought I would ask first. Thanks for the replies.

BC

Bruce,

What is your popup sorted on? Nothing, according to your example. If you specify the popup to be sorted by your multi-valued telephone number, I think you will see your data repeated like you desire. With no programming. Tell me if I'm wrong.

- Oystein -

Hmmmm, I will give it a try.

BTW - How can I get "smaller" row number buttons on an edittable?

Bruce

Bruce,

Use the COLSIZE property and use -1 and the column position.

[email protected]

SRP Computer Solutions, Inc.

Don,

That question was too easy for you. Try this one instead: How can one get statics to display text running in the vertical direction, i.e, rotated 90 degrees CW or CCW?

- Oystein -

Oystein,

Never thought about doing it with static text controls. I don't know if it can be done. We have used BMP's, however, to accomlish the same affect.

[email protected]

SRP Computer Solutions, Inc.

Thanks Don.

BTW - Am I just missing all of these things in the documentation?

Before I post, I check the doc. (using F1 and search/index) then

search the site here; then I post.

BC

PS. speaking of doc. how can I find out information regarding users. Can I manipulate (add more info to) the users that are entered

via the application properties, create permissions?

In the past I have created 1 user there then my own users file for

name,add etc. and created my own login screen. Thanks again.

Bruce,

The question on row buttons is not documented. I believe we originally discovered the solution by looking at the POPUP source since it does the same thing. Sometimes I don't know what things are docced and what aren't. They are just in my head or in our code. That is often our "documentation" since we know exactly where to find what we are looking for.

OI does provide routines and documenation for user manipulation. Look for Create_User, Delete_User, and List_Users. Someone awhile back actually created a pure OI form/Basic+ replacement for the Database Manager's interface so it could be imbedded in an application. We use the other method you described: create a generic database user and build security and access around a custom user database.

[email protected]

SRP Computer Solutions, Inc.

Tip the monitor on its side.

View this thread on the forum...