What about macros?
You can use macros in your sql-statements, and fill the macros dynamically.
I've never used it, but seen it in Class WMSShipmentReservation Method
FindFloatingPickItemBatch, which uses the Macro InventDimJoin in a
select-statement.
HTH
Herbert
| Von: christuerk [mailto:[EMAIL PROTECTED]
| Gesendet: Freitag, 17. Dezember 2004 16:30
| An: [email protected]
| Betreff: [development-axapta] how can i create where-condition dynamic
|
|
| Hello all,
|
| how can i create a dynamic select, e.g.
|
| select firstonly table
| where field1 == value1 &&
| field2 == value2 &&
| (dynamic condition)
|
| the dynamic condition can be
| field3 == string1 ||
| field3 == string2 ||
| .....
|
| the string(n) values depend on an resultset of another select.
|
|
|
|
|
|
|
|
|
| Yahoo! Groups Sponsor
|
|
| ADVERTISEMENT
|
| <http://us.ard.yahoo.com/SIG=12994aq13/M=295196.4901138.607130
| 5.3001176/D=groups/S=1705006764:HM/EXP=1103384766/A=2128215/R=0/SIG=10
| se96mf6/*http:/companion.yahoo.com> click here
|
|
| <http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.30011
| 76/D=groups/S=:HM/A=2128215/rand=826106023>
|
| _____
|
| 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]
| =Unsubscribe>
|
| * 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 Sponsor
| --------------------~-->
| Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
| Now with Pop-Up Blocker. Get it for free!
| http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
| --------------------------------------------------------------
| ------~->
|
|
| Yahoo! Groups Links
|
|
|
|
|
|
|
| Yahoo! Groups Sponsor |
| Get unlimited calls to U.S./Canada |
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]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
