Popup Displays (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 08 OCT 1999 11:12:14AM Marty Rsenbloom wrote:

OpenInsight Specific

I transfer selected data from one table to another and want to select some of the data on the new table. I created a popup for this, but during the same event that copies the data the popup is called. The display is empty even though table browser shws the data as being there. A test run of the popup will now work. It seems as if there is a timing problem in that the time that the new table gets the data and the time that the popup is called is too short. How do I overcome this?

Marty

At 08 OCT 1999 12:08PM Don Bakke wrote:

Marty,

Is there an index on this table that the PopUp is dependent on? If so, you might want to run Update_Index or Index.Flush just prior to launching the PopUp.

dbakke@srpcs.com

SRP Computer Solutions

At 08 OCT 1999 12:34PM Don Miller - C3 Inc. wrote:

Another possibility:

Stuff variable @USER0 with the keys to the records as they are copied. Separate the keys with either a @VM or @FM (depending on your use). Then select the records using these keys and call your popup or feed them into QBFLIST in the form you want to display them in.

Sample code:

@USER0='

L0:

READNEXT @ID THEN
 READ @RECORD FROM SRC_FILE,@ID THEN
    .. COPY LOGIC
     @USER0=@ID  ; OR @USER0=@ID  ;* 1ST IS FM 2ND IS VM
 END ELSE 
END ELSE

* END OF JOB

* FOR POPUP
SEL_LIST=@USER0
SWAP @FM or @VM WITH '" "' IN SEL_LIST
SEL_LIST=QUOTE(SEL_LIST)
CMD=SELECT  ':SEL_LIST
CALL RLIST(CMD......)
REPOSITORY EXECUTE THE POPUP
* FOR QBFLIST

* EXECUTE THE FORM

* IN THE CREATE_PARM CHECK FOR @USER0 AND SET THE QBFLIST PROPERTY

* TO CONTAIN IT

END

@USER0=' ;* CLEAR OUT WHEN THROUGH

Don Miller

At 08 OCT 1999 12:43PM Oystein Reigem wrote:

Marty,

Are you sure there's not something wrong with the popup definition?

How do you transfer data to the popup's table? Assuming you append data - what happens if you start with a table that already contains some rows? If it's a timing problem those rows ought to show.

Is this a networked app?

- Oystein -

At 08 OCT 1999 02:45PM Marty Rosenbloom wrote:

Oystein,

As part of the transfer process I empty out the "transfer to" table. When I test run the popup, a few minutes later it works fine. That's why I think it is a timing thing.

Marty

At 08 OCT 1999 02:48PM Marty Rosenbloom wrote:

Don,

There is an index on the columns that are called up. I will try as you suggest.

Thanks for all your assistance now and in the past, it is greatly appreciated.

Marty

At 10 OCT 1999 06:13PM Oystein Reigem wrote:

Marty,

You haven't by any chance got background indexing on?

- Oystein -

At 13 OCT 1999 11:51AM Marty Rosenbloom wrote:

Oystein,

I dohave indexing on and that was the problem. I updated the index and Voila there it was.

Thanks,

Marty

At 14 OCT 1999 08:54AM Oystein Reigem wrote:

Marty,

I got rid of background indexing a long time ago. I do a programmatic Update_Index in every data entry window, and in other tools I've made that changes data in indexed tables. I think it was Cameron that recommended it. It was a lot of work, but I'm glad I did it. I think it's easier when I always know my indexes are updated. And background indexing can cause other problems. (Search this list for "background indexing".)

- Oystein -

View this thread on the forum...