Filter in c/al

Durand
Durand Member Posts: 61
edited 2001-07-26 in Navision Financials
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

Comments

  • goofyfish
    goofyfish Member Posts: 5
    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).]

Categories