Helen Borrie wrote:

>
> At 05:43 PM 15-11-02 +1030, you wrote:
> >Creating a Trigger gives Error Msg: Invalid Column type: 0

...

> > if (:ParentID IS NULL) then <-- remove the colon from the variable
>
> Colitis (too many colons).

Thanks. I wondered why what the spots were in front of my eyes. <g>

> Just curious - are your customers breeding earthworms?
>

No. This relates to deer pedigrees.
--
Raymond Kennington
Programming Solutions
W2W Team B