The Pathway Extraction Caper

Legacy Poster

• 10. Juli 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 ★

  • 12. Juli 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

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.