Forum Discussion
BartJonges
May 21, 2023Copper Contributor
not all the records are shown by some queries.
Hi,
Some records in a table are not shown by some queries. But not all the queries have this problem. What can be the problem. Is there a property wrong installed?
- Tom_van_StiphoutSteel ContributorGive us a detailed example, along the lines of:
my table has a field with number - long integer data type, not required.
my query is "..."
The value "..." is in the table, but it is not being returned.
If you can post a sample database (one table, a few rows, one query) that demonstrates the problem, that would be even better.- BartJongesCopper ContributorDear Tom,
Thanks for your mail.
The problem is solved, the maintable was wrongly fill out in some records for the relation with a subtable. The input is constrained now.