Pass Command Line Data To Print 追蹤
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.
3 意見
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.
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.
Yes, see the below example:
string SQL = "SELECT `Calories` FROM `NutritionInformation`"; Engine btEngine = new Engine(); LabelFormatDocument btFormat = btEngine.Documents.Open(@"C:\NutritionLabel.btw"); ((OLEDB)btFormat.DatabaseConnections[0]).SQLStatement = SQL;
請登入寫評論。