Jim,
You *CANNOT* pass a parameter to a trigger - and it does not make any sense - because
a trigger is called when something happens to the data of a table. However, you can
create a new field in the table, pass the parameter into the field, and the trigger
will be able to pick it up.
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, 21 June 2001 15:33
> To: Multiple recipients of list delphi
> Subject: RE: [DUG]: [DUB-DB] trigger with parameter
>
>
> Hi,
>
> The reason I want to pass a value as I want to write the value
> into another table which is different that the table I update.
> The value is not from original table, but from client program. I
> hope I can set the value to somewhere like a parameter, and then
> update the original table, thus trigger another table to be
> updated with the value passed.
>
>
> Cheers,
>
> Jim
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
> Sent: 2001年6月13日 15:41
> To: [EMAIL PROTECTED]
> Subject: Re: [DUG]: [DUB-DB] trigger with parameter
>
>
> Jim
>
> A trigger is internal (fired by an event on the table) so what do you
> mean by pass a value to it?
>
> Neven
>
> ----- Original Message -----
> From: Jim Zheng <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Wednesday, 13 June 2001 15:10
> Subject: [DUG]: [DUB-DB] trigger with parameter
>
>
> > Hi all,
> >
> > Does anyone know how to pass a value ( not a field in the update table)
> into
> > a trigger? I am trying to build a MS SQL server version of our product.
> >
> > Cheers,
> >
> > Jim
> >
> >
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
