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 13 FEB 1999 09:49:33AM Nick Stevenson wrote:

Yippee Cameron (on the news re: RLIST abort scheduled for 3.8 (hopefully))..

I have experimented with your suggestion (and Don's I think) about implementing this in a symbolic for now. My symbolic code is:

declare subroutine YIELD

YIELD()

if @user1=ABORT' then

  ABORT ALL

end

@ans='

My form's OK button clears @user1 when the RLIST select is started. The form's ABORT button simply sets @user1 to "ABORT".

The select takes 4 seconds (on about 3,000 rows) WITHOUT the symbolic column in the select statement. This jumps to 12 seconds WITH the symbolic included.

When I remove the YIELD() statement, my response goes back to just over 4 seconds (acceptable). BUT I then cannot click my ABORT button as input is inhibited while RLIST works.

I suppose I could use a memory variable as a counter and only do the YIELD() every 1000 rows or so (or even every few seconds), but is there another way of doing it so as to reduce the effect on the speed of the select?


At 16 FEB 1999 01:32PM Cameron Revelation wrote:

Nick,

First, save off @dict, @id, @mv, @record before you call Yield and restore after it returns.

Second, yes do a counter (or time elapse) and yield every so often. I suggest using GetTickCount (Win API) or whatever it is called. It "ticks" like 18 times a second.

Cameron Purdy

Revelation Software

View this thread on the forum...

  • third_party_content/community/commentary/forums_nonworks/7d321e45a984bbb185256717005170e4.txt
  • Last modified: 2023/12/28 07:40
  • by 127.0.0.1