Re: Developer 2000 in inside-out

Hi,

inetnow wrote:
>
> I am new to the environment, but here is a problem and I will appreciate
> some help.
>
> Is it possible to have a trigger on one or the tables, which when fired can
> activate a specific form in the MDI application.
> The idea is to have one form hidden and controlled by the table level
> trigger.
>
> Thanks for help

Hmmm .. I am not really sure what it is you're asking here. If you're asking if a DBMS trigger (as in the CREATE TRIGGER STATEMENT) can activate a program on a client, then the answer i a clear NO. But you can have a application waiting idle on a client waiting for some startup command from a pipe for instance, and then wake up. The trigger then sends the start command using the pipe, and your problem should be solve.

But I would personally never use an application that just "popped up" out of nowhere. And what if something happend 2000 times a second? It's not really a matter of posibility but if this is what you want.

If what you want is to follow/log what happend on a table, you have 2 posibilities ... 1) make a log table yourself, and in a DBMS trigger write to this table everytime something happens to the table. 2) use the AUDIT functions already present in Oracle to trace activities on a table (not the row).

Does this answer your question?

• Peter H. Larsen Oracle Consultant