Problem With Sql View On Ole Db Connection

Legacy Poster

• 2016年01月09日 13:04

I'm having real problems trying to create a new label format that links to a SQL View via an OLE DB Provider for SQL Server Connection (BarTender Version 2016 R1 32 bit).

 

I can select the required SQL View and see all the fields. However there is an additional field that is causing problems. The field is called "TimeStamp" and I don't want it. It is not displayed on my SQL View and must be a system added field. The problem is when I select the "Filter" tab I get the error message "Error: Invalid Column Name 'TimeStamp' ". How can I remove this field?

 

 

 

0

• 

  Ian Cummings

  版主

  ★ BarTender Hero ★

  • 2016年01月10日 10:04

  You could switch to the "SQL Statement" view, enable it, and then remove the field you don't want from the SQL statement.  Another thing you could try is to set-up and alias for the field name, via the "Fields" via, if this is causing a problem somehow.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2016年01月11日 17:18

  Hi Ian. I went down the route of manually editing the "SQL Statement" and this works for me. Thanks for your help.

  0

請登入寫評論。