Record picker printing different records than selected 关注

0

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 

2 评论

0
Avatar
Otto Roberson
版主
评论操作 固定链接

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
Avatar
Christopher Peters
评论操作 固定链接

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

请先登录再写评论。