SETRANGE & |

JKoB

Hey!

How can i use SETRANGE with 2 criteria?

Present Code: SETFILTER("Location Code",'<>%1','Loc1');

Should be expanded to "Loc1|Loc2"

Thx in advance...

Jakob

idiot

SETFILTER("Location Code",'%1|%2','Loc1','Loc2');

garak

you can't use setrange ;-) u must use setfilter.

setfilter(MyField,'%1|%2|%3','Bla','Blup','Gurkenrost');
//or
setfilter(MyField,'Bla|Blup|Gurkenrost');
//or
MyFilterstr := 'Bla|Blup|Gurkenrost';
setfilter(MyField,MyFilterStr);

follow also the link
viewtopic.php?f=23&t=26739


Regards
Regards

JKoB

Hmmm...

setfilter(MyField,'%1|%2|%3','Bla','Blup','Gurkenrost');

doesnt work...

cause i need the "<>" (<>hannover|Kröpke)

Setfilter was clear so far (just made a typing error)

garak

JKoB wrote:

Hmmm...
cause i need the "<>" (<>hannover|Kröpke)

Hannover without the Kröpke? Never [-X :-D

use this:

setfilter(MyField,'<>%1&<>%2','HannoverRules','Kröpke');

for the other example:

setfilter(MyField,'<>%1&<>%2&<>%3','Bla','Blup','Gurkenrost');

Regards

navuser1

JKoB wrote:

Hmmm...

setfilter(MyField,'%1|%2|%3','Bla','Blup','Gurkenrost');

doesnt work...

cause i need the "<>" (<>hannover|Kröpke)

Setfilter was clear so far (just made a typing error)

you are asking for not equal to ...Then try
SETFILTER(MyField,'<>%1|<>%2|<>%3','Bla','Blup','Gurkenrost')

MBerger

navuser1 wrote:

JKoB wrote:

Hmmm...

setfilter(MyField,'%1|%2|%3','Bla','Blup','Gurkenrost');

doesnt work...

cause i need the "<>" (<>hannover|Kröpke)

Setfilter was clear so far (just made a typing error)

you are asking for not equal to ...Then try
SETFILTER(MyField,'<>%1|<>%2|<>%3','Bla','Blup','Gurkenrost')

That won't work, because Blup IS not equal to Bla, it will still pass. As stated in a previous post, you need to use <>%1&<>%2&<>%3

navuser1

MBerger wrote:

navuser1 wrote:

JKoB wrote:

Hmmm...

setfilter(MyField,'%1|%2|%3','Bla','Blup','Gurkenrost');

doesnt work...

cause i need the "<>" (<>hannover|Kröpke)

Setfilter was clear so far (just made a typing error)

you are asking for not equal to ...Then try
SETFILTER(MyField,'<>%1|<>%2|<>%3','Bla','Blup','Gurkenrost')

That won't work, because Blup IS not equal to Bla, it will still pass. As stated in a previous post, you need to use <>%1&<>%2&<>%3

Ouch.
BIG Mistake

JKoB

garak wrote:

JKoB wrote:

Hmmm...
cause i need the "<>" (<>hannover|Kröpke)

Hannover without the Kröpke? Never [-X :-D

setfilter(MyField,'<>%1&<>%2','HannoverRules','Kröpke');

Regards

works pretty fine... Thx

last thing 2 say:
'<>%1&<>%2','Hannover','Kröpke' := '<>%1&<>%2','Hamburg','Reeperbahn' 8)

[Solved]