# OrderHed.SalesRepList returns blank in ODBC

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-11-16 17:23 UTC
**Views:** 616
**Replies:** 1
**URL:** https://www.epiusers.help/t/orderhed-salesreplist-returns-blank-in-odbc/36320

---

## Post #1 by @ckrusen

When I query the OrderHed table via ODBC, the SalesRepList filed is blank.  But a BAQ of the table confirms the data is there.

Do I have to cast the returned data somehow?

---

## Post #2 by @Edge

Try creating a view and looking at the Pro_Element function

https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dmsrf/openedge-sql-functions.html

---


**Canonical:** https://www.epiusers.help/t/orderhed-salesreplist-returns-blank-in-odbc/36320
**Original content:** https://www.epiusers.help/t/orderhed-salesreplist-returns-blank-in-odbc/36320