AnsweredAssumed Answered

Returning a text box / message string containing SQL query results in Python

Question asked by Avitale on Oct 10, 2014
Latest reply on Oct 13, 2014 by bixb0012

Hello all,

 

I’ve bumped into a bit of a specific question, and I’m reaching out for help. 

 

Several years back, I started using Model Builder scripts in Python and running them as Scheduled Tasks (No problem).  Since some functions and calculations can be run more efficiently by SQL rather than ESRI tools within a Model, I’ve also begun to add some SQL queries and code into my Python script that are based on the Model builder results (all within the same python script).  An example of this is here.

 

Here is my issue:

 

I now need to return a message box or text string to the user from the Python script containing results of the SQL code used within the same Python script.  I can get a message box, but I need the message box to contain certain query results.  Has anyone else tried this?  Do you have any resources that might be able to help? 

 

Contact me if you need further details. 

Outcomes