Find Question/Issue

Classic Servoy
1

I have a large Oracle DB, testing two connected tables in Servoy.

I have a relationship set between the two, seems to work fine.

But, there are some records in the main file that do not join to a record in the second file. I want to find those records.

I tried doing a find with the “^” character in a related field, from a form based on the main file, but Servoy does not find the records. I’ve tried sorting the set by the related value, but I only seem to get records that have related records, never the ones with the null values.

I can do a find on a specific record and the record will display with no values in the relationship. So what am I doing wrong?

Thanks,
Lee Snover

2

how do you search for the main records??
is the relation

main → child

or do you have it the other way around

child → main

?
In the first case the form that shows the main records you will see the main records that don’t have child records.. Because the relation is only used for a query to show the childs for every main

in the other one you will not see that main records without childs. Because there is just no path to them.