FILTRE avec F7

Consul26Consul26 Member Posts: 5
Bonjour,
Navison 2009 R2 6.00.32012
J'utilise Navsion depuis la version 2 et je rencontre un problème avec la fonction FILTRE (F7)
depuis Navison 2009 R2 6.00.32012
Quand je Filtre la liste des ClIENTS <>*s je n'obtiens AUCUN resultat ?
Idem avec la fonction SETFILTER
SETFILTER(Code,'<>*s');
FINDFIRST;
Avez vous une idée ?
--
Hello,
I use Navsion since version 2 and I have a problem with the FILTER function (F7)
since Navison 2009 R2 6.00.32012
When I filter the list of Customers <>*s I get ANY result?
Same with the function SetFilter
SetFilter (Code, '<>*s');
FINDFIRST;
Have you any idea?

Merci d'avance
Stéphane
Stéphane

Comments

  • krikikriki Member, Moderator Posts: 9,112
    SETFILTER(Code,'<>*s'); will NOT work on a native DB. But it works fine on SQL server.

    The base idea is this : if you have a "<>..." and a "*" in the "..."-part, it will not work on a native DB, but on SQL it works fine.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • Consul26Consul26 Member Posts: 5
    Merci,
    Thank
    Stéphane
Sign In or Register to comment.