DevForce Community Forum : First ReadOnly relation is always retrieved http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : First ReadOnly relation is always retrieved Sat, 25 Apr 2026 11:16:45 -700 Wed, 07 Sep 2011 21:20:43 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2952 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ First ReadOnly relation is always retrieved : Ahh, that sounds like it. Will... http://www.ideablade.com/forum/forum_posts.asp?TID=2952&PID=11641#11641 Author: agrogers
Subject: 2952
Posted: 07-Sep-2011 at 9:20pm

Ahh, that sounds like it.  Will test this and post my results.  Thanks Kim]]> Wed, 07 Sep 2011 21:20:43 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2952&PID=11641#11641 First ReadOnly relation is always retrieved : We have seen this before with... http://www.ideablade.com/forum/forum_posts.asp?TID=2952&PID=11640#11640 Author: kimj
Subject: 2952
Posted: 07-Sep-2011 at 7:33pm

We have seen this before with the XtraGrid.  When EnableMasterViewMode is enabled, the grid will call the getter for the first list property of the bound type, apparently to determine whether to display the + icon.  If you aren't displaying detail records then setting OptionsDetail.EnableMasterViewMode to false should stop this behavior.]]> Wed, 07 Sep 2011 19:33:04 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2952&PID=11640#11640 First ReadOnly relation is always retrieved : We have found what seems like... http://www.ideablade.com/forum/forum_posts.asp?TID=2952&PID=11634#11634 Author: agrogers
Subject: 2952
Posted: 07-Sep-2011 at 12:29am

We have found what seems like a weird problem.  We have a list of Names being displayed in a DevEx grid.  When those names are displayed in the grid there is an extra unnecessary query being fired against the DB.  That query was retrieving all related student records and the relation happened to be the first in the list.

We could not work out why that one was firing so we decided to change it to a non-readonly relation.  That fixed our problem :)

But now the *next* read-only relation (now the first read-only relation) in the list is being fired for each row in the grid. 

Is this by design?  If so, what is the reason for this design?  If not, is there a way to stop these additional queries?

Thanks
Andrew
]]> Wed, 07 Sep 2011 00:29:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2952&PID=11634#11634