nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Make Query Table works in Python Window but not as Tool???

LonnieBilyk

Hi,

I'm a newbie at coding, so I hope my question is clear.

The below code works perfectly when I run it in the Python Window of 10.1.

But when I make a tool and attach the script, it runs and indicates that the script completed successfully but yet the table is not added to the TOC. Why will it not automatically appear?

Any ideas? I've tried so many things to make the table appear, I can't even remember anymore.

Lonnie

import arcpy, datetime, arcgisscripting, os
from arcpy import env

# Local variables.
tableList = "Database Connections/Database.odc/FWS_WMIS.FWI_INVENTORY_PROJECT;Database Connections/Database.odc/FWS_WMIS.FWI_INVENTORY_SURVEY"

fieldList = "FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID 'INVENTORY_PROJECT_ID';FWS_WMIS.FWI_INVENTORY_SURVEY.INV_SURVEY_ID 'INV_SURV_ID';FWS_WMIS.FWI_SURVEY_CREW_FNC(FWS_WMIS.FWI_INVENTORY_SURVEY.INV_SURVEY_ID) 'SURVEY_CREW'"
whereClause = "FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID=FWS_WMIS.FWI_INVENTORY_SURVEY.INV_PROJ_ID AND FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID=17909"
keyField = "FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID"

#Get the current date and time.
now = datetime.datetime.now()

#Use the current time as the name for the layer to produce a unique name for every layer.
lyrName = now

# Make Query Table.
arcpy.MakeQueryTable_management(tableList, lyrName,"USE_KEY_FIELDS", keyField, fieldList, whereClause)

Find more posts tagged with

Accepted answers

All comments

TomBrabant

I am having a similar issue running

arcpy.MakeQueryTable_management (['XYfeatureTable'], "q92","ADD_VIRTUAL_KEY_FIELD","",[["XYfeatureTable.EHANDLE"]],"")

The function executes and it has done something, because if I try to run it again with out changing the "q92" to something else, it tells me that it can't run (this second time) because "q92" already exists. I've tried to access this result several ways without success.

Unfortunately, I am running 10.2.2.3552 and it seems that arcpy.gp.MakeQueryTable_management

does not exist in this version.

curtvprice

Just highlighted just as a test of GeoNet. I did this by pasting the code, selecting the code, picking the advanced editor (upper right), selecting >> icon, syntax highlighting -> Python.

import arcpy, datetime, arcgisscripting, os
from arcpy import env

# Local variables.
tableList = "Database Connections/Database.odc/FWS_WMIS.FWI_INVENTORY_PROJECT;Database Connections/Database.odc/FWS_WMIS.FWI_INVENTORY_SURVEY"
    
fieldList = "FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID 'INVENTORY_PROJECT_ID';FWS_WMIS.FWI_INVENTORY_SURVEY.INV_SURVEY_ID 'INV_SURV_ID';FWS_WMIS.FWI_SURVEY_CREW_FNC(FWS_WMIS.FWI_INVENTORY_SURVEY.INV_SURVEY_ID) 'SURVEY_CREW'"
whereClause = "FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID=FWS_WMIS.FWI_INVENTORY_SURVEY.INV_PROJ_ID AND FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID=17909"
keyField = "FWS_WMIS.FWI_INVENTORY_PROJECT.INV_PROJ_ID"


#Get the current date and time. 
now = datetime.datetime.now()


#Use the current time as the name for the layer to produce a unique name for every layer.
lyrName = now
    
# Make Query Table.
arcpy.gp.MakeQueryTable_management(tableList, lyrName,"USE_KEY_FIELDS", keyField, fieldList, whereClause)

This looks a little buggy. I'm wondering if the fieldList were constructed as a Python list whether it would parse correctly using the normal interface (not going through the old "gp" module connection).

LonnieBilyk

Sorry for the slow reply. Things got busy.

I got it figured out and the on-line examples are not clear.

This doesn't work:

arcpy.MakeQueryTable_management(tableList, lyrName,"NO_KEY_FIELD", keyField, fieldList, whereClause)

This works:

arcpy.gp.MakeQueryTable_management(tableList, lyrName,"NO_KEY_FIELD", keyField, fieldList, whereClause)

The only difference is the "gp".

As I said, maybe this is simple, but it sure wasn't obvious to me. Thanks for everyone who spent time on this one.

AmyKlug

can you posting the entire code showing where you have a parameter defined?

a possibility from the code you posted......a query table is intermediate only, you can use CopyRows (as parameter) to make a permanent table that will appear in your table of contents

Here is how to post code:

http://forums.arcgis.com/threads/48475-Please-read-How-to-post-Python-code

KevinBell

a couple thoughts here:

geoprocessing menu/gp options/ check 'add gp results automatically' (maybe this one's too simple)

or

addLayer = arcpy.mapping.Layer('pathToMyLyr.lyr')
arcpy.mapping.AddLayer(df, addLayer, 'TOP')
arcpy.RefreshActiveView()

LonnieBilyk

Thanks.

I do remember trying that one. I just tried it again and I get the same result: the script indicates that it ran successfully but the table does not appear in the TOC.

It's killing me...

JasonScheirer

You'll need to make your table an output parameter of your tool. Only tables and layers that are specified as outputs will be added to the table of contents, the geoprocessing framework assumes any other layers and tables that aren't named are intermediate data.

So do this:

Add a parameter to your script tool: Output, Table View
At the end of your script, use arcpy.SetParameterAsText(0, lyrName) to pass the table along

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.