Print Page | Close Window

What is 1=0 there for?

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=2086
Printed Date: 19-Apr-2024 at 12:35pm


Topic: What is 1=0 there for?
Posted By: agrogers
Subject: What is 1=0 there for?
Date Posted: 23-Aug-2010 at 6:51pm
Hi

When we use the profiler to view the query being sent to SQL Server there is an entry in the where clause that reads ((1=0)) as shown below.  What might be producing that?

select * from "dbo"."ReportCardSubjectCriteria" where (((Deleted = 0) AND UserAccessId IN (1,2)) and ((1 = 0)))

Thanks
Andrew


Replies:
Posted By: kimj
Date Posted: 24-Aug-2010 at 1:30pm
In DevForce Classic the (1=0) queries are issued to gather schema information at runtime. 

Posted By: agrogers
Date Posted: 24-Aug-2010 at 4:55pm
OK, many thanks for that info.


Print Page | Close Window