Hallo Salvatore Besso,

> hello Set,
>
>> Could it be treating the comma as a decimal separator
>
> it could, but it would be a serious bug IHMO.

it's a known issue for years.

So it's a good advise to write IN( 1 , 2 , 3 ) Space-Comma-Space for
value delimiter and to write IN( 1,5 , 2,5 , 3,5 ) for decimal value
list. It works and users *can* understand such a syntax.

> it could, but it would be a serious bug IHMO. But isn't the period the
> decimal separator recognized in SQL scripts?

QBE is not a script but part of UI so supporting decimal separator
(comma for most of European countries) at this place is a far better
behavior of your application and expected by users for sure.

--
Andreas