Column Aliases 关注

0
Avatar
Legacy Poster

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

1 评论

0
Avatar
Domingo Rodriguez
版主
评论操作 固定链接

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?

请先登录再写评论。