SETFILTER issue

Washout · 2008-06-12

my first post....Im new to coding in navision

How do you SETFILTER on a Field type Text if the the String contains special chars like '('

I am trying to Filter as follows

rItem.SETFILTER("Main Title",tDescription)

but i think it is failing because of invald chars in tDescription

I get an error message

The Filter 'ABC (DEF)' is invalid

bbrown · 2008-06-12

Welcome the world of NAV

Try this:

rItem.SETFILTER("Main Title", '%1', tDescription);

Waldo · 2008-06-12

or:

rItem.SETRANGE("Main Title", tDescription);

DaveT · 2008-06-14

Hi Washout,

As Eric (Waldo) says setfilter solves this but also I would recommend using SETRANGE over SETFILTER as it is more efficent.

I only use SETFILTER for wildcards.

A big Fáilte to Nav and Mibuso

Waldo · 2008-06-16

Fáilte ?

DaveT · 2008-06-16

Hi Eric,

It's the Irish for Welcome - I know rule.... don't post in foreign language but I couldn't resist - Irish people on Mibuso are a rare breed

SETFILTER issue

Comments

Categories