Ms Sql Stored Procedure Parameter From Trigger File

Legacy Poster

• 25. Juni 2014 18:56

How do I pass field1 from the Commander trigger file as a parameter for a stored procedure in Bartender?

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • 25. Juni 2014 21:12

  You mean to pass a value into a query prompt in the BarTender document to run a database query???  First create a label design with a DB connection and make a query with a query prompt.  Then using something like Commander Script use the /?QueryPrompt1="ABC123" command line, where QueryPrompt1 is the name of you query prompt (you can set a different name) and "ABC123" is the value you're passing in the query.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 26. Juni 2014 16:11

  You mean to pass a value into a query prompt in the BarTender document to run a database query???  First create a label design with a DB connection and make a query with a query prompt.  Then using something like Commander Script use the /?QueryPrompt1="ABC123" command line, where QueryPrompt1 is the name of you query prompt (you can set a different name) and "ABC123" is the value you're passing in the query.

   

  Thanks!  That worked... Here is my commander script..

   

  %BTW% /AF="C:\Commander\Templates\Label_4x6.btw" /PRN="SPRC110" /?Param1="1018856"  /C=1 /P
  %END%
  
  

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.