Description: In TABLES mode, I have used EDIT to configure a table containing 39 fields and can successfully enter values into all fields and/or view the contents of all fields using forms in FORMS mode. However, if I am in TABLES mode and just double-click on a table name, some fields are not shown. A similar result occurs in QUERIES mode if I select a query which asks for all fields in the table. Steps to Reproduce: To assist in re-creating the problem, my configuration for the table is :- Field# Type Auto? Entry? Length Format 1(key) INTEGER Y - 10 0 2 VARCHAR_IGNORECASE - Y 50 @ 3 VARCHAR_IGNORECASE - Y 50 @ 4 DATE - N - 01/01/1900 5 DATE - N - 01/01/1900 6 DATE - N - 01/01/1900 7 DATE - N - 01/01/1900 8 LONGVARCHAR - N 0 @ 9 INTEGER N N 10 0 10 INTEGER N N 10 0 11 INTEGER N N 10 0 12 INTEGER N N 10 0 13 VARCHAR_IGNORECASE - N 50 @ 14 VARCHAR_IGNORECASE - N 100 @ 15 VARCHAR_IGNORECASE - N 100 @ 16 VARCHAR_IGNORECASE - N 50 @ 17 VARCHAR_IGNORECASE - N 50 @ 18 VARCHAR_IGNORECASE - N 50 @ 19 BOOLEAN - N 0 - 20 VARCHAR_IGNORECASE - N 50 @ 21 VARCHAR_IGNORECASE - N 50 @ 22 VARCHAR_IGNORECASE - N 100 @ 23 VARCHAR_IGNORECASE - N 100 @ 24 VARCHAR_IGNORECASE - N 50 @ 25 VARCHAR - Y 1 @ 26 VARCHAR_IGNORECASE - N 100 @ 27 VARCHAR_IGNORECASE - N 100 @ 28 VARCHAR_IGNORECASE - N 150 @ 29 VARCHAR_IGNORECASE - N 150 @ 30 VARCHAR_IGNORECASE - N 150 @ 31 VARCHAR_IGNORECASE - N 150 @ 32 VARCHAR_IGNORECASE - N 150 @ 33 DATE - N - 01/01/1900 34 INTEGER N N 10 0 35 VARCHAR_IGNORECASE - N 50 @ 36 VARCHAR_IGNORECASE - N 150 @ 37 BOOLEAN - Y 0 - 38 BOOLEAN - Y 0 - 39 VARCHAR_IGNORECASE - N 250 @ Actual Results: Only 22 columns are displayed - in my configuration, they correspond to the first 11 fields and the last 11 fields. Expected Results: All 39 columns should be displayed. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko
Is it possible for you to attach an example database? Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the file.
When I tried to create a simplified version of my database, I found I could not reproduce my problem. Re-examining my original database, I discovered that, probably quite a long time ago, the relevant columns had been marked as Hidden when displaying tables in Table View. By selecting "Show All", all columns were correctly displayed, so there was no fault - apologies if I wasted a lot of your time. Marking status as RESOLVED NOTABUG
(In reply to Alan Wheeler from comment #2) > tables in Table View. By selecting "Show All", all columns were correctly > displayed, so there was no fault - apologies if I wasted a lot of your time. You didn't waste much time at all, that is why we use NEEDINFO a lot :) If you sometimes feel like helping, you can check out the currently unconfirmed Base bugs and try to reproduce: https://bugs.documentfoundation.org/buglist.cgi?bug_status=UNCONFIRMED&component=Base&list_id=694352&query_format=advanced&resolution=---
Customers who order from us get their essays completed by highly qualified individuals. Every writer you hire from https://buyessay.net/ our assignment service has undergone a background check to confirm their credentials.