While the query composing engine for worksheet databases is very good as comes to defining a new query, it falls flat when changing one.
The criteria are listed in a fixed sequence and saying "Fewer" deletes the last one, not the one you want to get rid of. Let's assume one wants to exclude a layer from a query. In this process one first has to delete several other criteria, then recreate those.
I can do it. Islandmon can do it. I hate doing it. Joe Average can't do it.
Can we please have tick boxes or something to define which criterion or criteria we want to delete.
An "advanced" mode would also be welcome, to define ANDs and ORs arbitrarily. How about SQL? MapInfo has a very good SQL query builder. ArchiCAD has SQL, too.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
Petri
While the query composing engine for worksheet databases is very good as comes to defining a new query, it falls flat when changing one.
The criteria are listed in a fixed sequence and saying "Fewer" deletes the last one, not the one you want to get rid of. Let's assume one wants to exclude a layer from a query. In this process one first has to delete several other criteria, then recreate those.
I can do it. Islandmon can do it. I hate doing it. Joe Average can't do it.
Can we please have tick boxes or something to define which criterion or criteria we want to delete.
An "advanced" mode would also be welcome, to define ANDs and ORs arbitrarily. How about SQL? MapInfo has a very good SQL query builder. ArchiCAD has SQL, too.
Link to comment
7 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.