For your information I'm using TMap component.

And now I tried to make the filter directly on the SQL command on the prt table

That is to say on the request SELECT .... FROM PRT WHERE PRT.PRT_CAT='A'"

And with this filter it works, so is the TMap filter bugged or did I miss something ??

Thanks for your help !

Benoit,

Your solution will work well, but this info may also be helpful in other scenarios:

Generally when using .equals()  it is safer to put the constant first, as in "A".equals(prt_adh.PRT_CAT).  Because "A" will always be a string, you can always use the .equals() method on it.  If you use prt_adh.PRT_CAT.equals("A"), prt_adh.PRT_CAT may be null, and the null data type has no .equals() method, which is what was causing your problem.

Thanks,
Ben