• Industries
  • Products
  • Buy
  • Services & Support
  • Communities
  • Discussion Groups

    AutoCAD Civil 3D

    Reply
    Active Contributor
    Posts: 45
    Registered: ‎04-27-2012
    Accepted Solution

    Not equal query operator

    124 Views, 5 Replies
    09-20-2012 11:41 AM

    Hi,

     

    Is there any chance do query with excluding some data.

    For example, I have 20m contours and I'd like to separate them to major and minor one.

    I can extract major but not minor contours because there is no not equal query operator.

     

    Thanks for any help.

    Please use plain text.
    *Expert Elite*
    Posts: 1,745
    Registered: ‎12-18-2002

    Re: Not equal query operator

    09-20-2012 02:54 PM in reply to: Vasily_BC

    You need to explain your question more fully. What steps are you using to Extract the contours? Extract to where?

     

     

    Tim Corey, Owner
    Delta Engineering Systems
    Redding, CA
    Autodesk Authorized Value-Added Reseller
    Please use plain text.
    Active Contributor
    Posts: 45
    Registered: ‎04-27-2012

    Re: Not equal query operator

    09-20-2012 03:23 PM in reply to: tcorey

    Well, there is two options to do query right?

    Through data connect and through attaching a file.

    I do both of them, it depends on what kind of layout I need.

    So today I wanted to create a map with some contour lines.

    I have shp with all data I need but there is no style for it of course.

    So I decided to separate major contours and minor and set them us different layers.

    Query major contours isn't difficult. I've just set equal parameter like 100m, 200m and so on.

    But how to have contours in between of major contour lines? Have no idea.

    There is only =, <, >, =>, <= and <> operators.

     

    Thanks

    Please use plain text.
    *Expert Elite*
    Murph
    Posts: 1,589
    Registered: ‎11-13-2006

    Re: Not equal query operator

    09-20-2012 03:42 PM in reply to: Vasily_BC

    Vasily_BC wrote:

    Well, there is two options to do query right?

    Through data connect and through attaching a file.

    I do both of them, it depends on what kind of layout I need.

    So today I wanted to create a map with some contour lines.

    I have shp with all data I need but there is no style for it of course.

    So I decided to separate major contours and minor and set them us different layers.

    Query major contours isn't difficult. I've just set equal parameter like 100m, 200m and so on.

    But how to have contours in between of major contour lines? Have no idea.

    There is only =, <, >, =>, <= and <> operators.

     

    Thanks


    Well yes two different ways to query, depending on what one you use as to how. If you imported the shp files and create object data you "May" have data "Minor/Major" that you can query on. Also you can use the "/=" as in lisp to say not equal.

    With Data connect you can use the "Not Like" with the "Convert to string" function.

    Murph
    Supportting the troops daily.
    Please use plain text.
    *Expert Elite*
    Posts: 1,745
    Registered: ‎12-18-2002

    Re: Not equal query operator

    09-20-2012 03:47 PM in reply to: Vasily_BC

    Vasily_BC wrote:

    Well, there is two options to do query right?

     



    Now that I can see that you're using AutoCAD Map query functions, yes.


    Vasily_BC wrote:

     

    There is only =, <, >, =>, <= and <> operators.

     

     


    <> is Not Equal.

     

     

    Tim Corey, Owner
    Delta Engineering Systems
    Redding, CA
    Autodesk Authorized Value-Added Reseller
    Please use plain text.
    Active Contributor
    Posts: 45
    Registered: ‎04-27-2012

    Re: Not equal query operator

    09-20-2012 03:53 PM in reply to: Murph

    Finally I found that there were parameter with two variation. They are describe min and maj contours, but I think what if there'll be no such a data parameter? I've tried to use "not" and many other operators but always had an error.

     

    Anyway, thank you!

    Please use plain text.