Re: How to Execute a Trigger?

You cannot invoke a database trigger manually, it will only fie when the actual event on the table (insert, update etc) happens on the table.

Try putting the code in a stored procedure on the database. That way, you can call it manually and from the trigger.

Mark

laleonard_SpamBanana_AT_mindspring.com wrote in message <7lau72$l9b$1_at_nnrp1.deja.com>...
>A novice question: I have a "After Update" trigger on a column of a
>table. I am writing a C++ program, and I want to make this trigger
>fire.
>
>I know that I can make the trigger fire by simply writing to that
>column in that table, but is a more direct approach? I'm looking for
>something like:
>
> ::SQLExecDirect("EXECUTE TRIGGER MyTrigger");
>
>Thanks.
>
>==============================================
>Definitive Solutions, Inc - Makers of AprCalc,
>the Premier Shareware Mortgage Calculator for
>Windows. www.DefinitiveSolutions.com
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Jun 30 1999 - 03:05:06 CDT