Sorting changed by custom sql? BT 10.1SR4/Excel2010

Mary Snow

• 2017年06月23日 20:31

I'm not sure if this is just an SQL thing or a BarTender thing.

I have database connection to an Excel workbook with two spreadsheets in it. I join those two spreadsheets using custom SQL in BarTender. Neither spreadsheet has a numeric ID, the join is around a text field.

I want the query to keep the sorting order of the table CustOrders. Normally this is the way the data appears when I don't specify any ORDER BY. Except now that I've added an additional clause to my WHERE, it suddenly reverts to sorting by the first column instead of keeping the data in its original order. When I remove this line, sorting goes back to the way it should be.  Any idea why it might be doing this?  

For reference, my WHERE clause looks like this: 

WHERE `CustOrders$`.`Name` LIKE '?CustName%'
AND `Sheet1$`.`Full Item No` = `CustOrders$`.`Item`
AND ABS(`CustOrders$`.`Qty`/`Sheet1$`.`UnitQty`) >= 1  this is the line I added that apparently causes the sorting order to change.

0

• 

  Mary Snow

  ★ BarTender Hero ★

  • 2017年09月06日 15:44

  Any suggestions on this at all?

  0
• 

  Mary Snow

  ★ BarTender Hero ★

  • 2017年09月07日 12:37

  Got it working for now. I changed the language in my JOIN and that seemed to fix it.

  0

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