If you write withing anything within ' ' then it will assume it to be an
and you cannot get to choose wildcard entry. So you need to check for the
substring.
If you are using the while select then with that statement you cannot use
to check substring. You could write a while statement and then within that
statement you can write a IF statement where you check for substring
if(substr(LedgerTrans.Voucher,1,4) == 'F111')
Good luck,
Cheers,
Girish
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 14 March 2005 08:16
To: [email protected]
Subject: AW: [development-axapta] Select where with a filter
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: [email protected];
[email protected]
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=gr
oups/S=1705006764:HM/EXP=1110873160/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
etflix.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 Links
| 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.
