Filter in c/al

Durand

Hello,

I shall like leaking out a table on a portion of field (key), in C / AL, example:
Table containing 4 recordings: COSIMA, COSAN, COSINE, INECE
Filter COSI
Answer: COSIMA, COSINE
I tried the joker * in the SETFILTER but unsuccessfully.
Thank you for the help

Benoît
Formateur@ideaa.com

goofyfish

Hi there -

I scratched out a quick table with your 4 records
and used the following code in a codeunit:

mytable.SETFILTER(Name,'%1','COSI*');
IF mytable.FIND('-') THEN REPEAT
MESSAGE(mytable.Name);
UNTIL
mytable.NEXT = 0;

Using SETFILTER in this manner, I got 2 messages,
one with COSIME and one with COSINE.

Is this what you were looking for?

Rick

[This message has been edited by goofyfish (edited 26-07-2001).]