The Pathway Extraction Caper

Legacy Poster

• July 10, 2012 18:29

With Visual Basic 6, BT9.3 (Build 2704), WinXP

1. How is (not just the database name but) the entire filepath to a database extracted from a label format?
2. How is the SQL query that is stored in the label format extracted?

Set btdbase = btFormat.Databases.GetDatabase(1)
mySweetLittleSQLStatement = btDbase.OLEDB.SQLStatement (or ODBC) returns a blank string

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • July 12, 2012 10:04
  1. This is not possible, in the same way that a new database connection can be changed from your external automation application.
  
  2. I think you need to be using a Custom SQL statement in order for that to work.

  0

Please sign in to leave a comment.