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_Stiphout
May 21, 2023Iron Contributor
Give 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.
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.
BartJonges
May 22, 2023Copper Contributor
Dear 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.
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.