CREATE TRIGGER FEES_ADD FOR FEES BEFORE INSERT POSITION 0 AS
BEGIN
new.date_entered = "NOW";

END

I hope this helps

Thanks


At 00:45 04/03/2003 +1100, Helen Borrie wrote:

>At 03:41 PM 3/03/2003 +0200, you wrote:
> >Good day
> >\=-\=0-=-0-=0
> >I mean the client makes a remote connection and works fine but when in a
> >certain part of the program it makes a save to the database
> >and then the error occurs. There is NO trace of this error coming from our
> >source code and the only other place I can point to is the trigger as the
> >changes
> >are saved.
>
>So - what is the trigger? (this is like trying to squeeze blood out of a
>stone!)
>
>
> >Also a example is that ON the server I CANNOT get a Connection list as it
> >keeps on saying that the connection is lost the the database that I am
> >connected to.
>
>So - something crashed the server. A rogue UDF could do that.
>
>heLen
>
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/