Either we are doing something wrong, or we've found a bug in finding...
If we construct a form with fields from the table the form is based on
("MASTER") and also fields from a related table ("OTHER") then we can,
with apparently correct results, find records based on fields in the
MASTER or OTHER records. In this case, each MASTER record can have zero
or one related OTHER records.
We can also, again apparently correctly, logically OR two search requests
using criteria matching fields in the MASTER (Find; enter criteria; Add
Record; enter next criteria; ... Search). This also seems OK in a method.
So far, so good - but... if we then try to OR two sets of search criteria
where the first one specifies only fields in the MASTER (which by itself
would return some MASTER records which do not have related OTHER records)
and the second specifies field(s) in the OTHER record we then find that
the foundset excludes MASTER records which match the first set of criteria
but which do NOT hve a related OTHER record. I.e. the foundset of the
first request in the search appears to be influenced by referencing fields
in a related record in the second request of the find.
Are we doing something wrong, or have we tripped over a bug?
FWIW, this has been observed with Servoy 1.01 on two different platforms:
* Mac OS-X, Servoy 1.01, Java 1.4.1, MySQL
* Linux, Servoy 1.01, Java 1.3.1, PostgreSQL
Thanks,
Neale.