fetchMode is a 0 or 1 value, 0 being fetch 1:n and 1 being fetch 1:1.
It's a faster way of fetching if you know that you only have 1
corresponding record per parent record, such as the InventTableModule
data sources on the InventTable form.  They are (each individual DS),
1:1, although that property is not exposed in the GUI -- the forms
developers chose to link child data sources differently than reports &
queries for some reason -- hopefully they'll fix it some day...  So for
now, it's settable on reports and queries only, unless you build your
own through code.

________________________________

From: anton_tjiptadi [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 08, 2005 2:27 AM
To: [email protected]
Subject: [development-axapta] Fetchmode vs JoinMode




I'm a bit confuse about fetchmode and joinmode, what is exactly the
two method means ?

'cause sometimes a report can use fetch mode, but with value of
joinmode

for example :
QueryBuildDataSource1  = Query.adddatasource(tablenum(SalesTable));
QueryBuildDataSource2 = QueryBuildDataSource1.adddatasource(tablenum
(LedgerJournalTrans));

QueryBuildDataSource2.addlink(fieldnum(SalesTable, SalesId), fieldnum
(LedgerJournalTrans, SalesId));
QueryBuildDataSource2.JoinMode(JoinMode::Existjoin)
.
.
.

and then I see in some example using FetchMode, like this :
QueryBuildDataSource2.FetchMode(JoinMode::ExistJoin);
.
.

NB: the two example actually not related, but the point is, Is it
right to join table with FetchMode like example no.2 ? Example no 1
seems more logic to me....

I appreciate any kind of information :))
Thanks,











________________________________

Yahoo! Groups Links


*      To visit your group on the web, go to:
      http://groups.yahoo.com/group/development-axapta/
       
*      To unsubscribe from this group, send an email to:
      [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
be>
       
*      Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]



Yahoo! Groups Links

Reply via email to