Problem With Sql View On Ole Db Connection フォローする

0
Avatar
Legacy Poster

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?

 

 

 

2 コメント

0
Avatar
Ian Cummings
モデレータ
コメントアクション Permalink

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
Avatar
Legacy Poster
コメントアクション Permalink

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

サインインしてコメントを残してください。