How To Use Named Data Sources In Stored Procedure Follow
We are using Bartender Commander to process a text data file that our ERP system is generating. This file contains various data fields to print a label. These fields are mapped to Named Data Sources in the Bartender label design. We need to utilize a stored procedure to update a date code field in our database when the label is printed. The key to that update is a job # being passed from the text file to Bartender. How do we access those named data sources in the Custom SQL Statement input box?
My SQL statement is in the form of:
EXEC <stored procedure name> <job number>, <job suffix>, <Date Code OUTPUT>
I want to replace the <job number> and <job suffix> parameters with the named data sources job.job and job.suffix. The last parameter will be just NULL.
I tried query prompts and those work for testing, but I don't think those will work with the automated processing (non-interactive):
EXEC [ES_GetDateCode] '?JobNum', '?Suffix', NULL
I appreciate any assistance anyone can provide.