Print Page | Close Window

How to use 'Not In' Operator

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=865
Printed Date: 28-Mar-2024 at 9:06am


Topic: How to use 'Not In' Operator
Posted By: vinothvdp
Subject: How to use 'Not In' Operator
Date Posted: 27-Jun-2008 at 10:18pm
hello sir,
 
following query how to use entityquery pls any example
 
select * from "dbo"."Product" where (( "dbo"."Product"."ProductName" not in('xx','yy','zz'))
 
In this query used EntityQueryOp .'Not In' ,but ideablade don't have 'Not In' Operator so how to use in this query .
 
thanks



Replies:
Posted By: agrogers
Date Posted: 16-Mar-2010 at 5:36am
Hi

I would also like to know how to do a "NOT IN" operation in DevForce classic.  Does anyone have any suggestions?

Thanks
Andrew


Posted By: davidklitzke
Date Posted: 16-Mar-2010 at 9:38am
Start with an OQL query that contains a clause using the In operator.  Then modify the query with the Not operator.  See the Developer's Guide for examples using the In operator.


Posted By: agrogers
Date Posted: 16-Mar-2010 at 5:13pm
Ah, very good.  Thanks for your help David.



Print Page | Close Window