Re: not equal comparison operators (<> and !=)

[Peter Burton <pburton@BRIO.COM>]

Jamie,

The relational operatories "!=" and "<>" are treated in the same fashion by
SQR.  There is no difference between the two.

Peter

-----Original Message-----
From: Jamie Allen [mailto:jamesa@CYB.COM.AU]
Sent: Sunday, April 07, 2002 9:32 PM
To: SQR-USERS@list.iex.net
Subject: Re: not equal comparison operators (<> and !=)


I have had problems using the != in the likes of an IF statement before. In
fact it hasn't caused an error in one process but the logic is certainly not
applied as one would suggest.

I find the <> to be the safest bet and I have never seen it cause any real
perfromance implications.

Regards,

Jamie Allen
Analyst/Programmer
Century Yuasa Batteries
Australia



-----Original Message-----
From: Ken Boettger [mailto:BoettgeK@CWU.EDU]
Sent: Saturday, 6 April 2002 09:20
To: SQR-USERS@list.iex.net
Subject: Re: not equal comparison operators (<> and !=)


I was trying it withn an IF statement before the FROM clause. It generated
an error here on our platform.  Can someone confirm my observation here.
Are there cases where "!=" will be treated as a comment?  I feel guilty
about my first post to this thread and want to go home with a clean
conscious this weekend.

:)

-Ken

>>> Ivan.Turner@QWEST.COM 04/05/02 02:43PM >>>
sqr does not allow any comments between FROM and End-Select.  Therefore, !=
will not be treated as a comment.

-----Original Message-----
From: Roger Harris [mailto:RHarris@CSU.ORG]
Sent: Friday, April 05, 2002 5:20 PM
To: SQR-USERS@list.iex.net
Subject: Re: not equal comparison operators (<> and !=)


Using != does NOT get treated as a comment in SQR.  It works as intended.





                        Ken Boettger
                        <BoettgeK@CWU     To:     SQR-USERS@list.iex.net
                        .EDU>             cc:
                        Sent by:          bcc:
                        "Discussion       Subject:     Re: not equal
comparison operators (<> and !=)
                        of SQR, Brio
                        Software's
                        database
                        reporting
                        language"
                        <SQR-USERS@li
                        st.iex.net>


                        04/05/2002
                        02:38 PM
                        Please
                        respond to
                        sqr-users






Theoretically, yes and no.

But don't use "!"

I will likely be treated as a comment in SQR.  Use <> instead.

-Ken

>>> masonk@EVERGEGROUP.COM 04/05/02 01:16PM >>>
Do the comparison operators <> and != work exactly the same?

Is there a reason for using one over the other?

Thanks,

Kathy