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ån: [email protected] [mailto:[EMAIL PROTECTED] För Hemant Kumthekar Skickat: den 6 oktober 2005 05:00 Till: Axapta Ämne: [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 <http://groups.yahoo.com/gads?t=ms&k=Computer+part&w1=Computer+part&w2=Pro gramming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.sig=y LpvcLTIDJ5FTkRJGsO11w> Programming languages <http://groups.yahoo.com/gads?t=ms&k=Programming+languages&w1=Computer+par t&w2=Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=9 0&.sig=cuhEClK4dU4wapXFmKisbQ> Microsoft axapta <http://groups.yahoo.com/gads?t=ms&k=Microsoft+axapta&w1=Computer+part&w2= Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.si g=yfeG_U6QaLfPOZZIud02Fg> Support exchange <http://groups.yahoo.com/gads?t=ms&k=Support+exchange&w1=Computer+part&w2= Programming+languages&w3=Microsoft+axapta&w4=Support+exchange&c=4&s=90&.si g=hy8yRGMzrmxdphyITTUeqA> ________________________________ 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] > * 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 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 Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> 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: http://docs.yahoo.com/info/terms/
