Hi,
I issue a simple query (select * from “clients”) and certain fields do not show up !!!
Thanks helping me out
Regards
Alain
Example?
Database engine?
LOO version?
OS?
Ubuntu 20.10
LibreOffice 7.0.6.2
I transferred the .ODB under Windows 10 and latest LibreOffice 7.
Same results
Thanks helping me out
Alain
P.S. where can I upload the database to you ?
Hi,
I have attached the .ODB in an edited previous question.
If OK let me know.
Thanks again
Alain
And which query please uses select * from "clients" (which is stated in your question)? You are wasting helpers time by providing red herrings.
This is not working
SELECT R.Serial,
R.Deeddate,
R.Description,
R.LocationTw,
R.deedNature,
R.TV_REG_NUMBER,
C1.Title,
C1.Surname,
C1.OtherName,
C1.Address1,
C1.Address2,
C1.Address3,
C2.Title AS “DP_Title”,
C2.Surname AS “DP_Surname”,
C2.OtherName AS “DP_OtherName”,
C2.Address1 AS “DP_Address1”,
C2.Address2 AS “DP_Address2”,
C2.Address3 AS “DP_Address3”,
C3.Title AS “DPA_Title”,
C3.Surname AS “DPA_Surname”,
C3.OtherName AS “DPA_OtherName”,
C3.Address1 AS “DPA_Address1”,
C3.Address2 AS “DPA_Address2”,
C3.Address3 AS “DPA_Address3”
FROM repertoire R
LEFT JOIN clients C1 on C1.Client_ID = R.IDComparant
LEFT JOIN clients C2 on C2.Client_ID = R.IDComparant_DP
LEFT JOIN clients C3 on C3.Client_ID = R.IDComparant_DPA
Then I issued a simple query on the clients table (select * from clients) 4 cols showed up
The columns seems to be HIDDEN by default !!!
The columns seems to be HIDDEN by default !!!
It seems you may have hidden these columns in the table view. The query then inherited this trait. If you show the columns in the table view and save all, the query will work as you requested.
Hello,
- Right click on the header line of the query output
Show Columns -> All
