New Posts New Posts RSS Feed: What is 1=0 there for?
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

What is 1=0 there for?
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
agrogers View Drop Down
Groupie
Groupie
Avatar

Joined: 11-Mar-2010
Posts: 41 		Post Options Post Options   Quote agrogers Quote  Post ReplyReply Direct Link To This Post Topic: What is 1=0 there for?
    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
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 24-Aug-2010 at 1:30pm
In DevForce Classic the (1=0) queries are issued to gather schema information at runtime. 
Back to Top
agrogers View Drop Down
Groupie
Groupie
Avatar

Joined: 11-Mar-2010
Posts: 41 		Post Options Post Options   Quote agrogers Quote  Post ReplyReply Direct Link To This Post Posted: 24-Aug-2010 at 4:55pm
OK, many thanks for that info.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down