Record picker printing different records than selected

Scott Williams

• 2022年01月04日 23:38

When picking a record to print from a Database I select a single record and print and it prints something different than what I picked. i have also tried from the print dialog selecting the record.

Result 

0

• 

  Otto Roberson

  版主

  ★ BarTender Hero ★

  • 2022年01月07日 11:16

  Dear Scott, 

  Welcome to the BarTender Community Forums!

  Please try using the 'Sort Order' property page in the Database Setup Wizard, to force the records to be sorted by one or more fields in your database: 

  

  Best regards,

  Otto Roberson

   

  0
• 

  Christopher Peters

  ★ BarTender Hero ★

  • 2022年01月20日 20:22

  Scott - I had the same problem, and because I was using an ODBC connection I didn't have the options Otto mentioned in his answer.

  For me, the answer was to add an 'Order By' clause at then end of my SQL code, and make sure I listed every column in my document under that 'Order By.'

  It looks like when Bartender queries the database, it doesn't pull records in the exact order it looks like, unless they're sorted properly. So by sorting all the fields with that "Order By" it forces an order on to the records that makes it through to the end document. In the case of a direct query, as Otto laid out in his answer, you're able to force the sorting through Bartender. We found that direct SQL queries worked too slowly in our environment, but the ODBC connections make it faster.

  Hope that helps,

  Chris

  0

请先登录再写评论。