Column Aliases

Legacy Poster

• 5 de julio de 2013 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

  Moderador

  ★ BarTender Hero ★

  • 5 de julio de 2013 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

Iniciar sesión para dejar un comentario.