Re: Call form in userxit

Patrick de Ridder (deridder_at_worldnet.fr) wrote:
: I'm searching the way of calling a form (Oracle V7) in a userxit which is
: already call from a form , my problem is that if i'm using a runform it
: take too much place,because the second form can use too this userxiit and
: so on...

What operating system and how are you calling the forms from the userexit ?

A userexit is generally, but not always, C code and C has the ability to either call system() or do a fork() and exec(). That's what I guess your userexit is using to call the second form, right ??

In order for a given userexit to spawn a forms process that contains the same userexit, implies that you are spawning the same form or that the userexit is somehow fundamental to all forms ...

If this is the case, then I suspect that unless you have a very good reason for doing all of this, then your application is not particularly well designed :(

Are you aware that a form can directly call another form, which may simplify your userexit code ?

It seems that you need some sort of logic within the userexit that determines at what level of nesting it is at and then prevents further spawning of the form. It's possible that you could come up with mechanism of using a table/ view to keep track of the process names and number of instances per user, or perhaps even an OS specific kludge such as opening a pipe to the 'ps' command. But these are all not clean solutions and again I suggest that you revisit your overall design strategy.

Without additional detailed information as to what you are trying to achieve, then we on comp.databases.oracle.* - we are now a hierachy !! - will find it hard to help you on this.

IAP Received on Tue Oct 15 1996 - 00:00:00 CEST