Subscribe to this thread
Home - General / All posts - Identity index problem with auto-generated query after removing Group By
Mike Pelletier


1,966 post(s)
#06-Jan-22 18:20

The auto-generated join query works fine, but if you remove the Group By that it contains, it fails. The error complains about a problem with the identity index. When I open the schema for the query result the index is there but it doesn't appear to be working, as evidenced by the greyed out table.

Why should removing the Group By in the query affect this and is there a way to fix? Thanks for any thoughts.

Attached map has simple test data.

Attachments:
Identity Index problem with update query.map

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.