What does the FetchMode property on a query do? I will appreciate if someone will be able to give me very precise answer.
I know only implication of this parameter. It matters when exist/notexist joined datasources on the query are forming a tree - not a chain. If the tree of datasources is quite complex then your query has a very good chance not to work if FetchMode is not set to One2One.
To my knowledge it is related somehow to the way the kernel stores query datasources.
So, my rule of thumb is the following: if a query datasources form tree-like structure, FetchMode must be set to One2One everywhere exist/notexist join is used.
Example:
Query query;
QueryBuildDataSource qbdsInventTable;
QueryBuildDataSource qbdsInventItemGroup;
QueryBuildDataSource qbdsInventModelGroup;
;
query = new Query();
qbdsInventTable = query.addDataSource(tablenum(InventTable));
qbdsInventItemGroup = qbdsInventTable.addDataSource(tablenum(InventItemGroup));
qbdsInventItemGroup.relations(true);
qbdsInventItemGroup.joinMode(JoinMode::ExistsJoin);
qbdsInventItemGroup.fetchMode(QueryFetchMode::One2One);
qbdsInventModelGroup = qbdsInventTable.addDataSource(tablenum(InventModelGroup));
qbdsInventModelGroup.relations(true);
qbdsInventModelGroup.joinMode(JoinMode::NoExistsJoin);
qbdsInventModelGroup.fetchMode(QueryFetchMode::One2One);
I am actually writing a tutorial post about it, but it's going slow so far...
ReplyDeleteI would make a small change to your 'rule of thumb' - always use FetchMode::One2One, since you always actually expect a join, and not separate queries.
I can show you move info in the office :)
Vanya, I've been waiting some years for this blog post to show up...I can't find it on your blog.
DeleteVanya, I've been waiting some years for this blog post to show up...I can't find it on your blog.
DeleteHere is an other usage of the fetchmode-property
ReplyDeletehttp://www.crazy-club.de/blog/2010/04/fetchmode/
louis vuitton handbags
ReplyDeletemichael kors outlet online sale
christian louboutin outlet
oakley vault
louis vuitton handbags
ghd hair straighteners
true religion outlet
toms
kevin durant shoes
north face outlet
ralph lauren polo
nike uk
michael kors outlet clearance
nfl jerseys wholesale
christian louboutin sale
toms shoes
hollister clothing
michael kors outlet clearance
jordan 3 infrared
polo shirts
air jordan 13
polo ralph lauren outlet
adidas ultra boost
adidas shoes
gucci handbags
oakley sunglasses
coach outlet
ray ban sunglasses
christian louboutin shoes
kate spade handbags
coach outlet
michael kors outlet online
christian louboutin outlet
ralph lauren polo outlet
christian louboutin outlet
gucci
louis vuitton outlet
replica watches
timberland boots
louis vuitton handbags
20167.5wengdongdong
ray bans uk
ReplyDeleteugg outlet online
adidas nmd r1
coach factory outlet
moncler sale
uggs outlet
giuseppe zanotti shoes
polo outlet
ray ban glasses
christian louboutin sale
201612.10chenjinyan
مكافحة الصراصير المنزلية
ReplyDeleteشركه تسليك مجاري بالطائف
شركة عزل خزانات بالطائف
شركة تسليك مجارى بمكة
air jordan
ReplyDeletecheap jordans
timberland boots
supreme clothing
off white nike
hermes belt
jordan retro
golden goose sneakers
retro jordans
supreme clothing
have a peek at these guystheir explanation get redirected hereclick resources SourceYOURURL.com
ReplyDeletehttps://saglamproxy.com
ReplyDeletemetin2 proxy
proxy satın al
knight online proxy
mobil proxy satın al
V2XB
The Servicemembers Civil Relief Act provides protections for military members in real estate matters. timeshare cancellation
ReplyDelete