http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Comparing Two Columns in a Table Thu, 11 Jun 2026 09:26:37 -700 Wed, 27 Feb 2008 04:28:23 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=701 http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ http://www.ideablade.com/forum/forum_posts.asp?TID=701&PID=2605#2605 Author: cuneytgargin
Subject: 701
Posted: 27-Feb-2008 at 4:28am

Hi.
I am trying to create Entityquery for the query below .


Select * From Personel Where StillWorking=1 and LastEntryDate > LastExitDate

As you see, I am trying to compare two columns of the table
and Entityquery I created is as below :


EntityQuery query = new EntityQuery(typeof(Personel), Personel.StillWorkingEntityColumn, EntityQueryOp.EQ, true);
            query.AddClause(Personel.LastEntryDateEntityColumn, EntityQueryOp.GT, Personel.LastExitDateEntityColumn);

and it's wrong..

Beacuse in fact query expression seems to  be like

Select * From Personel Where StillWorking=1 and LastEntryDate > Personel.LastExitDate

check the last query sentence, it sees it like Personel.LastExitDate column...

How can I ?

Cheers

Cuneyt Gargin - Trinoks
]]> Wed, 27 Feb 2008 04:28:23 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=701&PID=2605#2605