[AccessD] Is operator

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