How To Have Label Run Sql Stored Procedure?
So we have a label that is connected to our SQL database and it does a great job of grabbing all the information we need, with one exception. We need our Lot Control number on this label also, however it doesn't exist until a stored procedure runs. How do I vb script this to run on the order range that the operator enters manually?
-
Easiest way I can think of is to write a small stored procedure of your own, call that stored procedure from the BT label with a custom SQL query using "exec" instead of a direct table query, and within your script, call the lot tracking procedure before returning all of the results. I'm doing something similar in several labels and it's pretty solid, although there are some peculiarities with bartender calling stored procedures that can make the app crash until you get it setup right.
You can avoid VBA altogether this route, but if you'd rather write VBA than a custom SP, then of course - you're not going to care for this method. :)
Trav-
0
Please sign in to leave a comment.
Comments
1 comment