How to use more than 1 statement in the action lists of a tri 
Author Message
 How to use more than 1 statement in the action lists of a tri

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C14B47.682C75F0
Content-Type: text/plain

That should be a comma between the 2 deletes not a semi-colon

Regards,
Bill Dare

Quote:
> -----Original Message-----

> Sent:      Tuesday, October 02, 2001 3:02 AM

> Subject:   How to use more than 1 statement in the action lists of a
> trigger ?

> Dear All:

>    I've tried the following statement , but it fails:
> =============================================================
> create trigger trigger1
> delete on member
> referencing OLD as oldtable
> for each row
> (delete from pointlog where account=oldtable.account;
> delete from issuelog where account=oldtable.account;
> );
> =============================================================

>    But if I remove one of the actions , it works.
>    I have to execute more than 1 statement in this trigger event, how
> should
> I compose of my SQL statement ?

>    Thanks in advance.



------_=_NextPart_001_01C14B47.682C75F0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: How to use more than 1 statement in the action lists of a =
trigger ?</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">That should be a =
comma between the 2 deletes not a semi-colon</FONT>
</P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Bill Dare</FONT>
</P>
<UL>

- Show quoted text -

Quote:
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

<BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Tuesday, October 02, 2001 3:02 AM</FONT>
<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 =

<BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>=
</B> <FONT SIZE=3D1 FACE=3D"Arial">How to use more than 1 statement in =
the action lists of a trigger ?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Dear All:</FONT>
</P>
<BR>
<BR>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">I've tried the following statement , but it =
fails:</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">create trigger trigger1</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">delete on member</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">referencing OLD as oldtable</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">for each row</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">(delete from pointlog where =
account=3Doldtable.account;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">delete from issuelog where =
account=3Doldtable.account;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">);</FONT>
<BR><FONT SIZE=3D2 =
FACE=3D"Arial">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">But if I remove one of the actions , it works.</FONT>
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">I have to execute more than 1 statement in this trigger =
event, how should</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I compose of my SQL statement =
?</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =
FACE=3D"Arial">Thanks in advance.</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 =

</P>
</UL>
</BODY>
</HTML>
------_=_NextPart_001_01C14B47.682C75F0--



Sat, 20 Mar 2004 21:37:40 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Using Action Statements in Office Pivot Tables

2. Arev 3.1 problem using OR in select and list statements

3. Clicking action in a list object?

4. Action that triggers a MDX Select statement

5. Executing Multiple Actions In A Case Statement

6. how to convert action integer to enum action type

7. Fill Combo List using Criteria selected in another Combo List

8. Fill Combo List using Criteria selected in another Combo List

9. Action Queries using an ODBC connection to SQL Server 6.5

10. HELP! Action using two Dimensions not working

11. Help Using actions - need to query SQL Database

12. insert statement using values from a select statement


 
Powered by phpBB® Forum Software