My ddf for the table has two fields i use as parameters for a selection. Both fields are separatly not uniqe, in field one is a object-number und field two is a option number. Each object can have various options. The sum of both fields is uniqe. The data definition is from the original software manufdacturer, i can not ask him for help, and now my problem:
the select statement:
select * from "TEST.BTR" where (option=1 and ObjID=88809)
but there are definitivly two records with the ObjectID 88809 one with the option=1 and one with the option 2. If i replace the option=1 by option>1 then the result contains both records, but i think option>1 is logical false for the first roe (option=1). I have no idea how to solve this. Is it possible that the ddf-declaration for the option-field is wrong?