Query problems

[GPSJane]

When using the 'Modify Query' dialogue is there a proper set of instructions somewhere for the syntax of all the elements? The help files have so far managed to tell me things I know like what an operator is but have absolutley nothing on what a geometric function is (and why my coordinate fields are separated from other fields or 'properties').

What the hell is wrong with SQL anyway? I would rather use SQL even if it means defining location boundaries myself!

I would very much like to know how to query my table on the X, Y, or Z coordinates.

z=integer gives me an error:

The expression is invalid
Error: The expression has an undefined property 'Z'. Click here to move the cursor to the error(0)#0

This is in Map 3D 2013 by the way.

[braudpat]

Hello

Q1) Are you speaking about Query with the MAP Drawings Group/Set ?

or Query with FDO ?

Q2) Can you share with us your Query ?

as a text file ...

[GPSJane]

---

@braudpat wrote:

Q1) Are you speaking about Query with the MAP Drawings Group/Set ?

or Query with FDO ?

---

I will guess the first one: Display Manager > Tools > Query to Filter Data

---

@braudpat wrote:
Q2) Can you share with us your Query ?

as a text file ...

---

Z=385

The error is at the 'Z'

[Murph_Map]

---

@braudpat wrote:

Hello

Q1) Are you speaking about Query with the MAP Drawings Group/Set ?

or Query with FDO ?

Q2) Can you share with us your Query ?

as a text file ...

---

From the description she posted it sounds like FDO connections.

[braudpat]

Hello

Ok you are using FDO ...

What is exactly the Z field : maybe a field coming from a SHP (or SDF or SQLite or Oracle Spatial or etc) through the Shape FDO driver ?!

[parkr4st]

if you queried z for elevation 385 with z = 385  try z = '385'  Looks like a syntax thing. 

Dave

[GPSJane]

---

@braudpat wrote:

Hello

Ok you are using FDO ...

What is exactly the Z field : maybe a field coming from a SHP (or SDF or SQLite or Oracle Spatial or etc) through the Shape FDO driver ?!

---

It is just a field in my database but ACAD Map decides it is special because it is a coordinate and won't let me use it like the other fields. The same applies to X and Y.

---

@parkr4st wrote:

if you queried z for elevation 385 with z = 385  try z = '385'  Looks like a syntax thing. 

Dave

---

I did try both of those and various other options too. There is no documentation on this random language that AutoCAD made up! Why can't I just use SQL?! *tearing hair out*

[Alfred.NESWADBA]

Hi,

if the Z-value us part of the geometry you can use the Expression Builder to bring it back as calculated field:

And when you have the field then you can create a filter or a stylization based on that value.

HTH, - alfred -

[GPSJane]

Wow! I have no idea where the logic in that syntax comes from but thanks.

I don't understand why this is not in the help documentation? Perhaps you can get them to update their help?

[Alfred.NESWADBA]

Hi,

great to know it works for you!

>> I don't understand why this is not in the help documentation? 

Well, let's say it's not easy to find, but it's there >>>click<<<.

- alfred -