Jan,

            Try altering your statement as below.



While select t

            Where (t.field1 == 1 && t.fieldA == 100 && t.fieldB == 200)
||

                       (t.field1 == 1 && t.fieldA ==500 && t.fieldB ==
700)





Regards

Tim



________________________________

From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Dahlsgaard Jan
Sent: Friday, January 20, 2006 4:34 AM
To: [email protected]
Subject: [development-axapta] OR criterias in query



Hi

I have a problem I can't solve, perhaps any of you have an idea.

I have a select-statement like this:

while select t
    where t.field1 == 1 &&
        ((t.fieldA == 100 && t.fieldB == 200) ||
        (t.fieldA == 500 && t.fieldB == 700))

How do I write this as a query instead ?

I have tried building the criterias in a string and supplied this as the
value (like in form address, datasource address, method
addQuerySalesTable), but can't get it to work properly. Any other ideas
?

Regards
Jan Stelsig Dahlsgaard
Fujitsu DK
       


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







________________________________

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]
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]






SPONSORED LINKS
Computer part Programming languages Microsoft axapta
Support exchange


YAHOO! GROUPS LINKS




Reply via email to