Main Menu Bar menus greyed out after Query Editor used

Product :4D - 4D Server
4D : v16R4 Hotfix
OS : Mac OS X 10.13.4

This problem occurs with V16R4 Hotfix. I no longer have a copy of V16R4. But I can confirm the problem does NOT occur with V16R3. It DOES occur with V16R5 and V16R6.

I have recently given a List Form its own Window. This was because Set Menu Bar had become problematic when Modify Selection was run in the Application Window. But this problem happens regardless of this choice.

This is a scientific database with MANY fields in the main Tables. I couldn’t believe we hadn’t noticed this before, but we have other ways of achieving the same result, other than using the Query Editor.

The problem ONLY occurs for a query, via the Query Editor, when the target field has a Choice List associated with it in the Structure Editor. Doesn’t matter whether the field is indexed or not. And it happens for all Tables.

So, when we use the Query Editor to search on a field with a choice field set, the choice list pops up, we choose from it, then proceed with the Query. The right selection of records results, but the menus of the main menu Bar is now greyed out. An attached menu is OK and works still. Alas Quit 4D is among the greyed out items!

I tried dropping the choice list from that field, and all is then OK. I deleted the List, and remade it. When I re-attach the List in the structure menu, the problem returns. And it occurs for all similar fields. ie. Choice list set in the Structure Editor. I haven’t yet found a way to programmatically drop the Choice List.

I can believe that Window choice could conceivably affect Menu Bars. But a Choice List? Really?

Steve Robertson

: Steve ROBERTSON

Product :4D - 4D Server

4D : v16R4 Hotfix
OS : Mac OS X 10.13.4

This problem occurs with V16R4 Hotfix. I no longer have a copy of
V16R4. But I can confirm the problem does NOT occur with V16R3. It
DOES occur with V16R5 and V16R6.

I have recently given a List Form its own Window. This was because
Set Menu Bar had become problematic when Modify Selection was run in
the Application Window. But this problem happens regardless of this
choice.

This is a scientific database with MANY fields in the main Tables. I
couldn’t believe we hadn’t noticed this before, but we have other
ways of achieving the same result, other than using the Query Editor.

The problem ONLY occurs for a query, via the Query Editor, when the
target field has a Choice List associated with it in the Structure
Editor. Doesn’t matter whether the field is indexed or not. And it
happens for all Tables.

So, when we use the Query Editor to search on a field with a choice
field set, the choice list pops up, we choose from it, then proceed
with the Query. The right selection of records results, but the
menus of the main menu Bar is now greyed out. An attached menu is OK
and works still. Alas Quit 4D is among the greyed out items!

I tried dropping the choice list from that field, and all is then OK.
I deleted the List, and remade it. When I re-attach the List in the
structure menu, the problem returns. And it occurs for all similar
fields. ie. Choice list set in the Structure Editor. I haven’t yet
found a way to programmatically drop the Choice List.

I can believe that Window choice could conceivably affect Menu Bars.
But a Choice List? Really?

Steve Robertson

The line of code causing trouble was:-

Query(theFilePtr->)

And the Menu Bar that greyed out was 2. Menu Bar 3 has very little on it except for File|Cancel. I don’t think it matters what Menu Bar I use for the next bit.

I replace the line above with:-

Set Menu Bar(3)
Query(theFilePtr->)
Set Menu Bar(2;*)

and I no longer have the problem. Not what I’d call a “solution”, more of a “fix”.

It is NOT enough to use:-

Query(theFilePtr->)
Set Menu Bar(2;*)

Steve Robertson