Skip to main content
Post Reopened by Devdatta Tengshe, Paul, Jason Scheirer, Brad Nesom, whuber
added 6 characters in body; edited title
Source Link
whuber
  • 70.2k
  • 16
  • 187
  • 282

How to create a model which executes a SQL Stored Procesurestored procedure with user provided-provided parameters?

How can I create an ArcToolbox that executes a SQL stored procedure and asks the user for 2two inputs?

As it stands now, I have to loginlog in to my SQL server and run an execute statement for the stored procedure that requires 2two inputs from the user.

I'm trying to streamline my process to give people with no SQL experience the ability to generate thisthese data through an ArcToolbox.

How to create a model which executes a SQL Stored Procesure with user provided parameters?

How can I create an ArcToolbox that executes a SQL stored procedure and asks the user for 2 inputs?

As it stands now, I have to login to my SQL server and run an execute statement for the stored procedure that requires 2 inputs from the user.

I'm trying to streamline my process to give people with no SQL experience the ability to generate this data through an ArcToolbox.

How to create a model which executes a SQL stored procedure with user-provided parameters?

How can I create an ArcToolbox that executes a SQL stored procedure and asks the user for two inputs?

As it stands now, I have to log in to my SQL server and run an execute statement for the stored procedure that requires two inputs from the user.

I'm trying to streamline my process to give people with no SQL experience the ability to generate these data through an ArcToolbox.

edited body; edited title
Source Link
Devdatta Tengshe
  • 41.6k
  • 35
  • 144
  • 263

ArcSDESQLExecute class and toolbox help How to create a model which executes a SQL Stored Procesure with user provided parameters?

Is it possible toHow can I create an ArcToolbox that executes a SQL stored procedure and asks the user for 2 inputs? 

As it stands now, I have to login to my SQL server and run an execute statement for the stored procedure that requires 2 inputs from the user. 

I'm trying to streamline my process to give people with no SQL experience the ability to generate this data through an ArcToolbox.

ArcSDESQLExecute class and toolbox help

Is it possible to create an ArcToolbox that executes a SQL stored procedure and asks the user for 2 inputs? As it stands now, I have to login to my SQL server and run an execute statement for the stored procedure that requires 2 inputs from the user. I'm trying to streamline my process to give people with no SQL experience the ability to generate this data through an ArcToolbox.

How to create a model which executes a SQL Stored Procesure with user provided parameters?

How can I create an ArcToolbox that executes a SQL stored procedure and asks the user for 2 inputs? 

As it stands now, I have to login to my SQL server and run an execute statement for the stored procedure that requires 2 inputs from the user. 

I'm trying to streamline my process to give people with no SQL experience the ability to generate this data through an ArcToolbox.

(Re-worded quesiton)
Source Link

I'm a complete noob whenIs it comespossible to python and I've got a few questions about the ArcSDESQLExecute option for calling a SP.

For my setup, we ran the SP and then usecreate an ArcToolbox that executes a SQL execute script to execute the SPstored procedure and to askasks the user for a 'name' and 'date'. This SP uses a feature2 inputs? As it stands now, I have to login to my SQL server and all of its associated featuresrun an execute statement for a certain condition and it is identified by the name and date inputstored procedure that requires 2 inputs from the user.

  I'm waningtrying to streamline my process by creating a toolbox that will call this SP and ask the user for a name and date that is required byto give people with no SQL experience the SPability to generate this data through an ArcToolbox.

  1. Is creating a toolbox like this possible?

  2. When creating the script with ArcSDESQLExecute, do I place the actual SQL script that created the SP or do I use the Execute script that we use in SSMS to call on the SP and allow for user input?

I'm a complete noob when it comes to python and I've got a few questions about the ArcSDESQLExecute option for calling a SP.

For my setup, we ran the SP and then use a SQL execute script to execute the SP and to ask the user for a 'name' and 'date'. This SP uses a feature and all of its associated features for a certain condition and it is identified by the name and date input.

  I'm waning to streamline my process by creating a toolbox that will call this SP and ask the user for a name and date that is required by the SP.

  1. Is creating a toolbox like this possible?

  2. When creating the script with ArcSDESQLExecute, do I place the actual SQL script that created the SP or do I use the Execute script that we use in SSMS to call on the SP and allow for user input?

Is it possible to create an ArcToolbox that executes a SQL stored procedure and asks the user for 2 inputs? As it stands now, I have to login to my SQL server and run an execute statement for the stored procedure that requires 2 inputs from the user. I'm trying to streamline my process to give people with no SQL experience the ability to generate this data through an ArcToolbox.

Post Closed as "Needs details or clarity" by PolyGeo, Jason Scheirer, Mapperz
edited tags
Link
PolyGeo
  • 65.4k
  • 29
  • 114
  • 345
Loading
Source Link
Loading