Code On Time needs to execute SPROC on record select
Budget: $15 – $25 USD
This will make sense if you have experience with Code On Time:
I need to make a SQL SERVER stored procedure execute when one record is selected in a grid, and the drop-down has a new entry other than select/edit/delete/new/duplicate. I need the SPROC to be passed the key value of the record that was selected. Seems simple, but I cannot seem to figure it out.
Example: Lets say I have a table of employees that has a primary key field “EmployeeID”. The user clicks on the EmployeeID field in the record for the employee he needs to make a new programmed electronic key for. COT drops down the menu which now has a “Make A Key” option in it as well as select/edit/delete/new/duplicate. When he clicks that option, a SQL stored procedure is executed. It gathers multiple pieces of data associated with the employee and builds a record in a table (?) which is then sent as a CSV file to the user's local computer's downloads file - just like the report action does now. A custom application that handles the programming of electronic keys is running on that PC. It observes the new file's arrival and uses the data from it to program a key, and then deletes the file.
The local PC app and programming of electronic keys is a done deal. Getting and reading the csv file is also simple. The ONLY part missing is how to make COT execute the SQL SERVER stored procedure when the user selects an employee and then clicks “Make a Key”.
Can I get some advice please?
I could make the user perform a NEW or UPDATE or other action and trigger the SPROC from that, but it would be much better done as a custom action.
I have been scanning the on-line docs for a week and just can't find the solution.
Thanks for whatever help you can give.
I need to make a SQL SERVER stored procedure execute when one record is selected in a grid, and the drop-down has a new entry other than select/edit/delete/new/duplicate. I need the SPROC to be passed the key value of the record that was selected. Seems simple, but I cannot seem to figure it out.
Example: Lets say I have a table of employees that has a primary key field “EmployeeID”. The user clicks on the EmployeeID field in the record for the employee he needs to make a new programmed electronic key for. COT drops down the menu which now has a “Make A Key” option in it as well as select/edit/delete/new/duplicate. When he clicks that option, a SQL stored procedure is executed. It gathers multiple pieces of data associated with the employee and builds a record in a table (?) which is then sent as a CSV file to the user's local computer's downloads file - just like the report action does now. A custom application that handles the programming of electronic keys is running on that PC. It observes the new file's arrival and uses the data from it to program a key, and then deletes the file.
The local PC app and programming of electronic keys is a done deal. Getting and reading the csv file is also simple. The ONLY part missing is how to make COT execute the SQL SERVER stored procedure when the user selects an employee and then clicks “Make a Key”.
Can I get some advice please?
I could make the user perform a NEW or UPDATE or other action and trigger the SPROC from that, but it would be much better done as a custom action.
I have been scanning the on-line docs for a week and just can't find the solution.
Thanks for whatever help you can give.