Latest Contributions by BenSmith

Thank you Brandon, I have verified that this does correct my issue.  I did not suspect the repeat count values but they were added late in the design and you reply explains how this problem seemed to start from "out of the blue". Ben ... View more

Brandon, So far I have only seem this behavior on the Survey123 for ArcGIS v2.4.72 client and on an iPhone6 running Survey123 v2.5.44.  I have attached the xls file. Thanks for the assistance, Ben ... View more

I know there are some esri examples in the help that describe creating a toolbox function that will take user input values. To pass variable such as user input to the SQL function I would do something like this with the SQL string. userDATE = (input from toolbox) userNAME = (input from toolbox) SQL = "SELECT WHERE DATE = '%s' AND NAME = '%s';" %(userDATE, userNAME) The ‘%S’ takes the variables userDATE and userNAME in order and substitutes them into the string. ... View more

Yes, after the SQL = should be your spatial query. That was a generic flat query from DB2 and was there just as an example. If you are calling a stored procedure then I would think it would be whatever commands you would use in the SQL tool you used to create and query when you created the SP. The query in the example I sent is formatted for a basic select against a DB2 database. ... View more

Try this using the arcpy.ArcSDESQLExecute function.  Not a spatial SQL function but it work the same way and return your results. workspace = "Database Connections\\GGE01000_ggadmin.sde" conn = arcpy.ArcSDESQLExecute(workspace) sql = "SELECT GROUPID FROM ggadmin.SCH_PAGE_DATA WHERE GROUPID IS NOT NULL AND ENABLE = 1 GROUP BY GROUPID;" GroupIDvalues = conn.execute(sql) ... View more