Creating triggers using table designer

Hi,

How to use the table designer to create triggers which are stored procedures?

I created a stored procedure and in Triggers group, I typed in the name of the stored procedure for the update trigger. I am getting an error informing me that the variable by the name of the trigger is not found?

How do I specify stored procedures for triggers in the table designer?

Regards

Gerben
Tue Jun 29 08:57:25 CDT 2004

There is nothing special at a trigger, just use

PROCEDURE NameOfTrigger
*- CODE
ENDPROC

And in the table designer use NameOfTrigger() as trigger name. But don't
forget the '()'

HTH,

Gerben Kessen
Wantit

"sm" <sm@discussions.microsoft.com> wrote in message
news:41447878-72A7-4AE0-B8BD-C863992187FC@microsoft.com...
> Hi,
>
> How to use the table designer to create triggers which are stored
procedures?
>
> I created a stored procedure and in Triggers group, I typed in the name of
the stored procedure for the update trigger. I am getting an error informing
me that the variable by the name of the trigger is not found?
>
> How do I specify stored procedures for triggers in the table designer?
>
> Regards

Anders
Tue Jun 29 09:15:14 CDT 2004

Hi Sm

Visually you create stored procedure from the Database Designer.
Use the database menu for Stored Procedure


In code
OPEN DATABASE x EXCLUSIVE
MODIFY DATABASE

You can also add programs to a database with APPEND PROCEDURE ..

In the Table Designer you enter a reference to a triggers on the Table page.
Type the trigger's name in the textbox:
mytrigger()
or use the command CREATE TRIGGER ON <table> FOR UPDATE AS mytrigger()
You still have to create the stored procedure as described above.
-Anders

"sm" <sm@discussions.microsoft.com> wrote in message
news:41447878-72A7-4AE0-B8BD-C863992187FC@microsoft.com...
> Hi,
>
> How to use the table designer to create triggers which are stored
procedures?
>
> I created a stored procedure and in Triggers group, I typed in the name of
the stored procedure for the update trigger. I am getting an error informing
me that the variable by the name of the trigger is not found?
>
> How do I specify stored procedures for triggers in the table designer?
>
> Regards

sm
Wed Jun 30 00:24:02 CDT 2004

The steps I had followed was correct. I had missed out on specifying '()' in the text box for the trigger.

Thanks.

"Gerben Kessen" wrote:

> There is nothing special at a trigger, just use
>
> PROCEDURE NameOfTrigger
> *- CODE
> ENDPROC
>
> And in the table designer use NameOfTrigger() as trigger name. But don't
> forget the '()'
>
> HTH,
>
> Gerben Kessen
> Wantit
>
> "sm" <sm@discussions.microsoft.com> wrote in message
> news:41447878-72A7-4AE0-B8BD-C863992187FC@microsoft.com...
> > Hi,
> >
> > How to use the table designer to create triggers which are stored
> procedures?
> >
> > I created a stored procedure and in Triggers group, I typed in the name of
> the stored procedure for the update trigger. I am getting an error informing
> me that the variable by the name of the trigger is not found?
> >
> > How do I specify stored procedures for triggers in the table designer?
> >
> > Regards
>
>
>