[AccessD] Is operator

Susan Harkins harkins at iglou.com
Sat Feb 1 16:18:13 CST 2003


Oh .. yeah... duh...

two different operators -- got it. <will go splash cold water on my red face
now>

Susan H.


> Absolutely correct.  It is used for something else in SQL because it's a
SQL
> command then, not a VB/VBA keyword.
>
> I have only ever used it for comparing objects, so I couldn't agrue
against
> the documentation.
>
> Drew
>
> -----Original Message-----
> From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
> Sent: Saturday, February 01, 2003 3:43 PM
> To: Susan Harkins; accessd at databaseadvisors.com
> Subject: Re: [AccessD] Is operator
>
>
> > All documentation refers to the Is operator as used to compare two
object
> > reference variables. But, we also use it in simple criteria expressions
in
> > queries, etc.
> >
> > So, what Is really?
> >
> > It's a comparison operator, but why does documentation define it as a
> > comparison operator for objects when we obviously use it for other
things?
> > The documentation just may be poor in implying that Is works "only with"
> --
> > or it's very specific and there's more to it than I understand.
> >
>
> The only place I've ever used IS to compare anything other than objects is
> in Queries.
>
> There it can only be used to compare a field or expression to NULL or NOT
> NULL..
> That is a very specific instance where you are using the syntax of Jet SQL
> not Access
> VBA. - it is the SQL version of the VBA function ISNULL().
>
> Can you give any case where you  use IS in VBA to compare anything other
> than
> objects?
>
>
>
>
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System Support.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>




More information about the AccessD mailing list