TUniQuery does not get all Fields

[heerdinm]

Hello,

I have the following Query:

Code: Select all

SELECT
  Curatoren.*,
  Kantoren.Naam,
  CuratorBenoeming.DatumBenoeming
FROM (Curatoren
INNER JOIN CuratorBenoeming
  ON Curatoren.benoemingID = CuratorBenoeming.Id)
INNER JOIN Kantoren
  ON Curatoren.kantoorID = Kantoren.Id;

I am using TUniQuery with a connection to a MSAccess DataBase.
Everything seems to run ok, except for 1 thing.
In the table Curatoren, there is a field named BeedigingStatus.
When i put that field in a TDbGrid, the Column shows, but there is not data listed for that column. All the other columns show data.

When i Put up a form and fetch the data from the TUniQuery, everything is taken from the table, except for the field BeedigingStatus.

When i run the exact same Query in MSAccess, i see every field and all the information. Nothing is missing. I deleted the field from the TDbGrid and added it again. Did the same for the TUniQuery Fields, but nothing happens. Can someone please tell me what is wrong here?

[scorp1on]

You are using version 4.6.11? If so, install the 4.5.10 and see if it is ok.

[AlexP]

Hello,

Thank you for the information, we have reproduced and fixed the problem, this fix will be included in the next build. If you have an edition with source code, I can send you the code for solving the problem.

[heerdinm]

Hello,

thank you. I only have the professional version. No source code.
Could you tell me when the next patch will be available?

TIA

[AlexP]

Hello,

We plan to release a new version in the next month.