Hi community,
strange enaugh this is the first time in years I have to do a retrieve in Uniface, "not like" equivalent
so the goal is to have retrieved data with first character not "I" and not "O" for the same field

in sql we easily do in this way:

select * from table where field not like "I%" and field not like "O%"

neither in the read u_where clause or retrieve directly in field, I can make it work

for example if I want to to a like clause I write in the code:

field.table = "I·*·|O·*"

this is correctly translated by the Uniface SQL driver into like I% or like O%

but if I want to do "NOT like", trying this way:

field.table = "·!I·*·!O·*"

is translated wrongly into not like I* and not like O* ,so translated with the * instead of the % symbol. that occurs the same way if I do this in the u_where clause

my bad (and ugly) workaround is to write this in the u_where clause:

read u_where (field.table < "I" | field.table > "Izzzzzzz") & (field.table < "O" | field.table > "Ozzzzzzz")

that points me to insert a condition the read trigger to work as a simple read, or that one

do you all have any suggestion?

thank you
Simone

------------------------------
Simone Pecchenino
Labinf Sistemi Srl
IT
------------------------------