Re: Insert with trigger

Brad

Thank you for helping me.

The trigger is specified like this:

*update *after
*insert *after

"Stone, Brad V (TC)" wrote:

> How is your trigger specified?
>
> For example.
>
> *Update, *After
> *Update, *Before
> *Add, *After
> *Delete, *Before
> etc...
>
> If you have more than one, please specify.
>
> Bradley V. Stone
> Taylor Corporation - OASIS Programmer/Analyst
> bvstone@taylorcorp.com
>
> > -----Original Message-----
> > From: Staffan Lofberg [SMTP:staffan.lofberg@netorom.se]
> > Sent: Friday, January 15, 1999 8:05 AM
> > To:   MIDRANGE-L@midrange.com
> > Subject:      Re: Insert with trigger
> >
> > I'm sorry I didn't tell you the problem in a clear way. It is when I
> > receive the
> > update that there is data in the "old stuff" but nothing in the "new
> > stuff"
> > section of the parameter. When the program is called when someone adds a
> > new
> > record in the file none of the sections contains any data.
> >
> >
> > Staffan Lofberg
> >
> > "Stone, Brad V (TC)" wrote:
> >
> > > On an add, the first parameter ("Old stuff") is the only portion that
> > > contains data.
> > >
> > > Bradley V. Stone
> > > Taylor Corporation - OASIS Programmer/Analyst
> > > bvstone@taylorcorp.com
> > >
> > > > -----Original Message-----
> > > > From: Staffan Lofberg [SMTP:staffan.lofberg@netorom.se]
> > > > Sent: Thursday, January 14, 1999 1:14 PM
> > > > To:   MIDRANGE-L@midrange.com
> > > > Subject:      Insert with trigger
> > > >
> > > > Hello
> > > >
> > > > I  am trying to write my first trigger program. It works OK when the
> > > > file is updated but not when I am adding new records to the file. When
> > I
> > > > looked into the result I saw that I only had information in the "old"
> > > > section and not in the "new" section of the parameter.
> > > >
> > > > What have I missed?
> > > >
> >

------------------------------------------------------------------
Netorom AB              Phone +46 40 6712272
P.O. Box 9160           Fax   +46 40 940128
S-200 39  Malmö         http://risc.netorom.se
Sweden                  mailto:staffan.lofberg@netorom.se


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---