I am getting the Bar Tender: Warning Message #2201 It is trying to pull data that I don't want!

Michael Clifford

• January 17, 2023 16:42

I got this on one label, so i tried to create a new label ONLY pulling data from a View... But it is pulling lots of unused data and i don't know how to fix this... 

0

• 

  Michael Clifford

  ★ BarTender Hero ★

  • January 17, 2023 22:35

  OK... I found the issue... I had to be very particular in the SQL Query... I changed the SQL Query to this, and it worked fine. Those brackets seemed to fix it. 

  SELECT DISTINCT 
  [Production Unit], 
  Nursery, 
  Customer, 
  [Activity Reference Number], 
  Color, 
  Shape, 
  [Item Code], 
  [PU Lot Code], 
  DESCRIPTION_1, 
  [Pack Lot Code], 
  [Trees per Bag], 
  [Chill Hours], 
  [Bag Elevation], 
  [Sales Order], 
  [Pack Date]
  FROM        
  vw_wy_RFID_MIMA

  0
• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • January 18, 2023 09:23

  Thank you for sharing the solution with the rest of the community Michael!

  0

Please sign in to leave a comment.