4

I am creating a very basic model tool for a class project and I am running into trouble getting the SQL values to populate. I have read the ArcGIS 10: How to populate SQL options for parameter in tool post. If I need to convert this model into a script tool I can but I was wondering if I can change something in the model before attempting to make it a script. here is a screen shot of the model.enter image description here enter image description here Basically I just want the user to be able to open the SQL builder and select NAME = "" but the values and fields are not populated I noticed in the other post you can specify to populate from another parameter in the script. Is there anyway to do this in the model if not what would I set as my feature parameter if I created a script. As you may have guessed I am a beginner with python and model builder so I appologize if this is a "dumb question". here is a screen shot of the layers att table if that helpsenter image description here enter image description here

  • is name a domain field? if not I think you will have to build your own available value list. – Brad Nesom Sep 30 '13 at 18:24
  • @Brad Nesom I dont think it is, its just a field of county names would I use the collect values tool to build a available values list? – landocalrissian Sep 30 '13 at 18:38
  • Can you include in your question a graphic of the Parameters tab of your model with the NAME field highlighted so we can see its settings, please? It looks like you may have it set to a data type of SQL Expression rather than Field. – PolyGeo Sep 30 '13 at 22:20
  • @PolyGeo good idea Im not in the lab now but I will post in the morning thanks for the help so far. – landocalrissian Oct 1 '13 at 0:38
  • @PolyGeo I have attached a screenshot of my parameters tab it is set as an SQL should it be set to something else I thought since the parameter is a variable from the select tools SQL option. – landocalrissian Oct 1 '13 at 13:03
2

One of my previous questions regarding building value list filters in modelbuilder may help.

This will allow the user to choose from a list of available options you have built into the parameter/model.

  • 1
    funny because I stumbled across your post about 30 minutes ago and it definatley helped I changed the select your AP County to a string variable with the the counties as a value list filter and used the "NAME" = '%Select your AP Counties%' for the SQL query in the select tool. I also did the same for the Aquatic Preserves parameter and it works now. Thanks all for the help I would vote this answer but I cant due to my lowly status. – landocalrissian Oct 1 '13 at 16:05
  • *definitely sorry – landocalrissian Oct 1 '13 at 16:14
  • @ChrisR you should be able to upvote this answer so perhaps try again – PolyGeo Oct 1 '13 at 19:25
  • @PolyGeo at the time I couldn't but now I can and have. Thanks again – landocalrissian Oct 3 '13 at 12:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.