TUniQuery does not get all Fields
Posted: Wed 23 Jan 2013 19:45
Hello,
I have the following Query:
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?
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;
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?