Print if DataSource is Found in Query 追蹤

0
Avatar
Christian Vargas

I need to set the following:

 

-- OnPrintJobStart

    -- IF "Named Data Source A"  IS FOUND WITHIN  "Query 1"

        -- THEN DON'T Print

            -- INSTEAD Display Custom Message

 

Please let me know how to set this in the correct SYNTAX in the VB SCRIPT Editor

2 意見

0
Avatar
Shotaro Ito
評論操作 永久連結

If you mean Query 1 is result (record set) from a SQL Select Query from a database,

BarTender doesn't have a good option as VB script cannot access to current connected database etc.

(you can query to Database by VB Script OLEDB such as 

http://forums.seagullscientific.com/topic/595-vb-script-dropdown-list-excel/ 

however I don't really recommend that.)

For cancel print, please check below

https://support.seagullscientific.com/hc/en-us/community/posts/115009553748-Print-IF-DataSource-Equals-Other-DataSource?page=1#community_comment_115005638548 

0
Avatar
Christian Vargas
評論操作 永久連結

Understood. However, what if I create the Query in SQL server, and have it feed the data I need to another table name Table 2.

Then is it possible to do the following?

 

-- IF "Named Data Source A"  IS FOUND WITHIN  "Table 2"

    -- THEN DON'T Print

登入寫評論。