Record picker printing different records than selected
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.
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:
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,