Forum Discussion

BartJonges's avatar
BartJonges
Copper Contributor
May 21, 2023

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?

  • 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.
    • BartJonges's avatar
      BartJonges
      Copper 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.

Resources