Print if DataSource is Found in Query

Christian Vargas

• November 14, 2017 16:21

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

0

• 

  Shotaro Ito

  ★ BarTender Hero ★

  • November 15, 2017 02:35

  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
• 

  Christian Vargas

  ★ BarTender Hero ★

  • November 15, 2017 02:49

  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

  0

Please sign in to leave a comment.