setfilter with special chars

Business Central/NAV Developers Forum
1

Hi, could any one tell me, how to setfilter on a field which would look more or less like this: (200 and by the way - how to show the “” in a message box

2

For example: MESSAGE(‘Hello %1 World!’,’’); You may also find this recent topic interesting: http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=13374

3

Yep, that worked out fine, what about the first problem?

4

SETFILTER(Field,’=(200’); or SETRANGE(Filed,’(200’);

5

well, this:

quote:

SETFILTER(Field,‘=(200’);

won’t work but this:

quote:

SETRANGE(Filed,‘(200’);

yes and it appears that you can’t set such filter if you have an opened table window :frowning:

6

quote:

and it appears that you can’t set such filter if you have an opened table window :frowning:
Originally posted by fufik - 2005 Feb 11 : 08:58:19

You can - set filter =‘(200’ In C/Al you should write: SETFILTER(Field,‘=’‘(200’‘’);

7

when you want to place a single apostrophe inside a text constant then you need to write two single apostrophes inside a text So the text : My car is ‘yellow’ and I want to sell it when you write it into a text variable in C/AL code you write: [code] textvar := ‘My car is ‘‘yellow’’ and I want to sell it’; [code]

8

Hi Here is an example: For the demo I have created a Text Constant: Text000 %1 and the Code should look like this: e.g. Vend.setfilter(Name,’%1’,strsubstno(Text000,FilterStr)); form.runmodal(FORM::“Vendor List”,Vend); You use the same syntax when you want to set a filter as ‘’ (blank). e.g. Vendor.setfilter([FieldName],’%1’,’’) Regards, Steen Fisker