Pass Command Line Data To Print

Legacy Poster

• February 03, 2016 23:04

Hi,

I’m connecting my application with BarTender SW and I want
to pass a parameter from my application to the Bartender and print the label
pertaining to the passed parameter (record) without popping up ‘select records ‘window.
Therefore, how do I pass a parameter(specific record data) in the command line and
what would be the changes have to make for SQL statement in the database setup?

 

Your reply greatly appreciated.

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • February 04, 2016 11:43

  You'd use the /?<queryPromptName> command line switch.  The default query prompt name would look like this: /?QueryPrompt1="ABC123"

   

  *"ABC123" is an example criteria value you're passing to the query for the purposes of your print job.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • March 08, 2016 03:49

  Is there any possibility to pass the whole sql statement(command line) to bartender ?  And bartender needs to set the input string as sql statement. Because my sql is a customized query.

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • March 28, 2016 13:07

  Yes, see the below example:

   

  When using an OLE DB or ODBC database connection, custom SQL statements may be used to perform record filtering when data browsing or to select database records at print time. To apply custom SQL statements, use the SQLStatement property.

   

  The following code demonstrates how to set a custom SQL statement when using an OLE DB database connection.

   

  string SQL = "SELECT `Calories` FROM `NutritionInformation`"; 
  Engine btEngine = new Engine();
  LabelFormatDocument btFormat = btEngine.Documents.Open(@"C:\NutritionLabel.btw");
  ((OLEDB)btFormat.DatabaseConnections[0]).SQLStatement = SQL; 
  
  

  0

Please sign in to leave a comment.