qbdsStat.relations(true);
qbdsStat.joinMode(JoinMode::ExistsJoin);
which never seems to work for me. I have to use
qbdsStat.addLink(FieldNum(Persons, Pnr),FieldNum(FamStatus, Pnr));
has anybody got a clue what that is all about...
anyhow.. with that in mind this works just fine
qbrStat.value(strFmt('(((Salary > 3000) && (Persons.Age <20)) ||
((Salary < 400) && (Persons.Age > 50)))'));
for ex to show that it really works. If you still cant get it to work just give us a shout and I ll send you an xpo.
Thomas.
________________________________
Från: [email protected] genom zekvelda
Skickat: fr 2005-12-02 09:05
Till: [email protected]
Ämne: [development-axapta] Query to 'OR' two ranges
Hi
I have a request very similiar to post number 12021 concerning 'OR'ing
two different fields on a table in a query. I've tried the solution
proposed in post 12021 with no success.
My scenariois as follows:
I have a query on a table (MyTable). I want to return all the records
where 'Field1 == noyes::Yes' OR 'Field2 == noyes:Yes'. 'Field1'
and 'Field2' are two DIFFERENT field in 'MyTable'.
As was mentioned in the posts preceding post 12021, the default method
of creating two query ranges is an AND and I want an OR.
Has anyone successfully implmented an 'OR' for a BuildQueryRange? If
so, can you please share your method?
SPONSORED LINKS
Computer part <http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yLpvcLTIDJ5FTkRJGsO11w> Programming languages <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=cuhEClK4dU4wapXFmKisbQ> Microsoft axapta <http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=yfeG_U6QaLfPOZZIud02Fg>
Support exchange <http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=hy8yRGMzrmxdphyITTUeqA>
________________________________
YAHOO! GROUPS LINKS
* Visit your group "development-axapta <http://groups.yahoo.com/group/development-axapta> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* 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
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
