Column Aliases

Legacy Poster

• 2013年07月05日 08:11

Hey Guys

 

For some of my BarTender Labels we've created user defined SQL-Commands (accessing MySQL ODBC) in which i use aliases like

SELECT

tb.id AS ID

FROM

tablename AS tb
 

Before i've reinstalled BarTender 9.4 SR3 it was possible to set an object source to database field tb.id. After reinstalling the same BT version, it is possible to browse the data , but if i want to print the selected items, BarTender says there is no tb.id, instead of this i have to choose tablename.id. Is it my fault, what do i have to setup to get it working again?

 

Thanks

0

• 

  Domingo Rodriguez

  版主

  ★ BarTender Hero ★

  • 2013年07月05日 11:18

  Open BarTender's database connection dialog (via "File > Database Connection Setup"), locate the table name on the left pane, right click and choose "Edit Alias". Give it the Alias name of "tb".

   

  Will this help?

  0

請登入寫評論。