Hi.

I have an "AFTER UPDATE" trigger like that have this command:

.
.
IF OLDROW.CAJAS=NEWROW.CAJAS THEN LEAVE;
.
.

CAJAS is a field "DECIMAL NULLABLE" type


If value of field OLDROW.CAJAS=NULL and NEWROW.CAJAS=NULL don't leave the trigger but if
have another value yes.

Is correct this working?

Thank you

Francisco


>I have an "AFTER UPDATE" trigger like that have this command:

Its a secret and if we find out what it is you have to kill us - right?

Roy Lambert

"Roy Lambert" <roy.lambert@skynet.co.uk> skrev i en meddelelse
news:B6E3A0A7-B615-44F2-A2BF-4B4AD108E82E@news.elevatesoft.com...
> Francisco
>
>
>>I have an "AFTER UPDATE" trigger like that have this command:
>
> Its a secret and if we find out what it is you have to kill us - right?
>
>
> Roy Lambert
>

Francisco,

<< I have an "AFTER UPDATE" trigger like that have this command:

..
..
IF OLDROW.CAJAS=NEWROW.CAJAS THEN LEAVE;
..
..

CAJAS is a field "DECIMAL NULLABLE" type


If value of field OLDROW.CAJAS=NULL and NEWROW.CAJAS=NULL don't leave the
trigger but if
have another value yes.

Is correct this working? >>

Yes, what you want is this if you want to match NULLs also:

IF (OLDROW.CAJAS=NEWROW.CAJAS) OR
   ((OLDROW.CAJAS IS NULL) AND (NEWROW.CAJAS IS NULL)) THEN
   LEAVE;

--
Tim Young
Elevate Software
www.elevatesoft.com

Francisco,

2 null values are not equal to each other so you need an additional check:
.
.
IF (OLDROW.CAJAS IS NULL) AND (NEWROW.CAJAS IS NULL) THEN LEAVE;
.
.
Depending on what you want to do, you probably should be checking in the BeforeUpdate
TRIGGER rather than AfterUpdate TRIGGER.

Richard Harding

I was amazed when I saw Tim's response. I thought "where did he get the information". I think its a bug in my newsreader, probably to do with a single dot on a line but I'll find out later.

Roy Lambert

It doesn't look as though its a bug in my newsreader (or at least not just mine). Winmail also fails. Its the single . on a line with nothing else being translated as the end of the message.


Can I ask who can read the full text of the post and what news reader you're using?

Francisco & Richard - what did you use to post?

Roy Lambert

Roy Lambert wrote:

> It doesn't look as though its a bug in my newsreader (or at least not
> just mine). Winmail also fails. Its the single . on a line with
> nothing else being translated as the end of the message.
>
>
> Can I ask who can read the full text of the post and what news reader
> you're using?
>
> Francisco & Richard - what did you use to post?
>
> Roy Lambert

That's all I saw, also.  I use Xananews.

--
David Cornelius
CorneliusConcepts.com

>Roy Lambert wrote:

>It doesn't look as though its a bug in my newsreader (or at least not just mine). Winmail
also fails. Its the single . >on a line with nothing else being translated as the end of
the message.


>Can I ask who can read the full text of the post and what news reader you're using?

>Francisco & Richard - what did you use to post?

>Roy Lambert

Hi Roy.

I'm using  Newsgroups (Web) by firefox if is this that you are asking because with my
"spanglish" sometimes I don't understand well what are you writting.

Regards.

Francisco


That's exactly what I wanted - thanks. It tells me its probably Tim's web interface or FireFox that's not quite doing things right.

Roy Lambert