Hello, When I do a ds.Table.query() using a field/attribute of a non-indexed field, I get an error.
that has not been my experience. v18, Client/Server, non-indexed field, ORDA query has always worked just fine. --- are sure definitely sure that indexing is causing the problem? for instance, could it be that the table does not have a primary key? what is the field type? is it an object? what does the query string look like? does it include "linked" queries? (e.g. attr[a].attr = :1 and attr[a].prop = :2) can you reproduce the problem on a fresh DB? Of course, I can add an index, but then I seem to have restart the server for it to work. This is super inconvenient, obviously and in may cases not possible at that moment. Is there a command to run that reloads whatever list the ds.Table.query() uses to find field/attributes? Or Should I just index all fields? What do you all do? ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
