Hi,
You need to use * in Aaapra.
If you are selecting with wildcards you need to use the keyword "like" not "==".
/Jesper
Von: Padmaja Iyingar [mailto:[EMAIL PROTECTED]
Gesendet: Montag, 14. März 2005 05:06
An: development-axapta@yahoogroups.com; Axapta-Knowledge-Village@yahoogroups.com
Betreff: [development-axapta] Select where with a filter
Hi ,
I am trying to select Sum of accounts's AmoustMST for that particular Voucher series.
///For example I want to sum up all accounts only for the voucher F111*.
I can not do a substr in the select WHERE clause as its a database field.
'select LedgerTrans where LedgerTrans.Accountnum >= 1000 && LedgerTrans.AccountNUm <=2000 && LedgerTrans.TrandsDate= 1\1\2004 && LedgerTrans.Voucher == 'F111%' is not working......
I thought F111% is equal to F111*.
How can I selectively select this one?.
Can some one help please?
Thanks,
Padmaja Iyer.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129cv5dhj/M=298184.6018725.7038619.3001176/D=groups/S=1705006764:HM/EXP=1110873160/A=2593423/R=0/SIG=11el9gslf/*http:/www.netflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=:HM/A=2593423/rand=420965999>
_____
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]>
* Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor | |
|
|
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.