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 02 MAY 2003 08:26:38AM Dave Berkovsky wrote:

I have a form with number of edit field and a pushbutton. Push button

invokes store procedure that does very lengthy processing.

At that time entire system becomes unusable. Any suggestions

what should I do for this task to run in the background ?

Thanks

Dave Berkovsky


At 02 MAY 2003 09:50AM Donald Bakke wrote:

Dave,

Is this lengthy process running in a program loop of some kind (i.e. For..Next, While..Repeat, etc.)? An easy way to make the system still usable to an extent is to embed a Yield() statement within the loop.

Alternatively, you can utilize OI32's support for multiple and remote OpenEngines. If your process does not require any UI activity and it is running on a network then I would attempt to send this to a remote OpenEngine. Otherwise you can spin off another engine on the local workstation and pass it a request to run your process. Either way you can gain control over your system.

[email protected]

SRP Computer Solutions, Inc.


At 02 MAY 2003 01:58PM Dave Berkovsky wrote:

Don,

]Is this lengthy process running in a program loop of some kind (i.e. ]For..Next, While..Repeat, etc.)? An easy way to make the system ]still usable to an extent is to embed a Yield() statement within the ]loop.

Mostly it does the select and then loops reading reacords.

I do like your idea of multiple OpenEngines. I am kind of new

to this concept. Is it possible for you explain in detail

how it can be done. Or maybe there is a document or any type

of documentation.

Thanks in advance.

Dave


At 02 MAY 2003 02:17PM Donald Bakke wrote:

Dave,

I do like your idea of multiple OpenEngines. I am kind of new to this concept.

As are most people since it's only been available since OI 4.1.x

Is it possible for you explain in detail how it can be done. Or maybe there is a document or any type of documentation.

To get a general explanation of multiple OpenEngines I would refer you to the OI 4.1 New Features.pdf document that came with the 4.1 upgrade and the corresponding routines (i.e. CreateEngine) that are document in the Programmer's Guide help.

There are also a few posts around here that have touched on various issues, including this one from a certain arrogant Sprezz drone!

[email protected]

SRP Computer Solutions, Inc.

View this thread on the forum...

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