Hemant
axapta developer <[EMAIL PROTECTED]> wrote:
use:
.value(SysQuery::valueNotEmptyString())
ANIL OZAY <[EMAIL PROTECTED]> wrote:
Hi Hemant,
You can give SQL criteria for range, but it must be in paranthesis.
addRange( '(MyTable.MyField=="A") || (MyTable.MyField=="")')
You must use double quote for range values. This is the solution ;)
Regards,
Anil
-----Original Message-----
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Askeryd Thomas
Sent: Thursday, October 06, 2005 2:40 PM
To: [email protected]
Subject: SV: [development-axapta] Form Query
I'm pretty new to this but it should be possible to set the range value to
!(not) or >0 to get it the way you want. Maybe checking out the dev. guide
might help you.
Thomas.
________________________________
Fr宺 [email protected]
[mailto:[EMAIL PROTECTED] F?emant Kumthekar
Skickat: den 6 oktober 2005 05:00
Till: Axapta
Ä­ne: [development-axapta] Form Query
Hi Guys,
I wanted your help on the following problem.
I have a customized table, where in there are some records I wanted to
filter when I want to display on a form (grid). The main field is having
Blanks or Nulls, Need help on this. I had seen some examples using
ExecuteQuery in Datasource on Forms but they all seem to have some
specific value to be used as filter. In my case I want to eliminate the
records where the field has blanks / null.
Thanks in advance.
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer part
gramming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=y
LpvcLTIDJ5FTkRJGsO11w>
Programming languages
t&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=9
0&.sig=cuhEClK4dU4wapXFmKisbQ>
Microsoft axapta
Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.si
g=yfeG_U6QaLfPOZZIud02Fg>
Support exchange
Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.si
g=hy8yRGMzrmxdphyITTUeqA>
________________________________
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 .
________________________________
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Bu e-posta ve muhtemel eklerinde verilen bilgiler kisiye ozel ve gizlidir. Anadolu Bilisim Hizmetleri A.S. bu mesajin icerigi ve ekleri ile ilgili hicbir hukuki sorumluluk kabul etmez. Yetkili alicilardan degilseniz, bu mesajin herhangi bir sekilde ifsa edilmesi, kullanilmasi, kopyalanmasi, yayilmasi veya mesajda yer alan hususlarla ilgili olarak herhangi bir islem yapilmasi kesinlikle yasaktir. Bu durumda hemen mesajin gondericisini bilgilendiriniz ve mesaji sisteminizden siliniz. Elektronik mesajlar uzerinde yapilmis herhangi bir degisiklik veya sonuclari uzerinde Anadolu Bilisim Hizmetleri A.S.'nin sorumlulugu yoktur. Ayrica, e-posta mesajlarindaki hata ve/veya eksiklikten, virus icermesinden ve bilgisayar sisteminize verebilecegi herhangi bir zarardan Sirket olarak sorumluluk kabul etmeyecegimizi de bildiririz.
This e-mail and any information included within any attached document are private and confidential and intended solely for the addressee. Anadolu Bilisim Hizmetleri A.S. does not accept any legal responsibility for the contents of this message and any attached documents. If you are not the intended addressee, it is forbidden to disclose, use, copy, or forward any information within the message or engage in any activity regarding the contents of this message. In such case please notify the sender and delete the message from your system immediately. Anadolu Bilisim Hizmetleri A.S. also denounces any legal responsibility for any amendments made on the electronic message and the outcome of these amendments, as well as any error and/or defect, virus content and any damage that may be given to your system.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
[Non-text portions of this message have been removed]
SPONSORED LINKS
Computer part Programming languages Microsoft axapta Support exchange
---------------------------------
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.
---------------------------------
---------------------------------
Yahoo! for Good
Click here to donate to the Hurricane Katrina relief effort.
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
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.
