Thomas Derwin <[EMAIL PROTECTED]> wrote on 09/11/2006 10:18:29 AM: > The index says the "K-type" for your PRIM.BIN.NUM is "Txt", so looks > like the dict it's based on is left-justified (e.g. "3L") rather than > right-justified (e.g. "3R").
Colin Alfke <[EMAIL PROTECTED]> wrote on 09/11/2006 10:37:43 AM: > Make sure the dict for PRIM.BIN.NUM is set to "R#" ... Unfortunately, our "normal" Bin Numbers are alphanumeric (e.g., "A 6 B 2"), so the Text format is required. These "non-standard" bin numbers were inherited when we merged with another company. Even so, as I said in an earlier reply, why would this fail? >SELECT WAREHOUSE WITH PRIM.BIN.NUM >= "131" AND WITH PRIM.BIN.NUM <= "139" Whether you look at the data numerically or alphabetically, I shouldn't see bin numbers that don't begin with 13. ========== Allen Egerton <[EMAIL PROTECTED]> wrote on 09/11/2006 10:49:05 AM: > 3) If you want the combined select, I'd try: > SELECT WAREHOUSE WITH PRIM.BIN.NUM > 130 AND WITH PRIM.BIN.NUM < 140 We're in ECLTYPE P, which requires the quotes. Also, my users wouldn't understand why "13DWG" would be included in this selection. ========== David A. Green <[EMAIL PROTECTED]> wrote on 09/11/2006 10:50:40 AM: > Also try using BETWEEN like this: > :SELECT WAREHOUSE WITH PRIM.BIN.NUM BETWEEN "131" "139" Also a problem in ECLTYPE P - the specified strings are NOT included with the BETWEEN keyword. --Tom Pellitieri Century Equipment ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
