database trigger

[saintneo007]

is it possible to place the database trigger procedure file in the server instead in the client workstation

 

[Norman Biggar]

You can place the trigger procedure on the client workstation IF the client workstation is connected directly to the database, and not by an appserver.

The trigger must be visible in some way to the database. If you are connected directly to the database, you can specify the trigger location using the -trig database connection parameter.

If you are using AppServer or WebClient, you will have to keep the trigger code on the server.