On Fri, 2004-09-17 at 10:40, Glenn Herbert wrote: > Exactly how does the SELECT fail? 0 items returned? hang? crash?
Zero items... In this application, one person purchases based on invoiced items. however, if this particular item isn't working, quotes go into the purchasing screen, thus causing items only quoted to clients being ordered. Not a good thing. The syntax that was failing was standard enough (DICT=TYPE, 3=Quote): STMT = 'SELECT BKORD WITH F26 = "" AND F10 > 0' STMT := ' AND F01 = "N" AND TYPE # "3"' STMT := ' AND F02 = ':WHOUSENO:' BY VENDNAME BY NAME BY @ID' EXECUTE STMT CAPTURING NOTHING -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] Here's the I-Desc again: 0001 I 0002 TRANS(BOHDR,(ORDER.NUMBER),'5','X') 0003 0004 ORD?TYP 0005 2R 0006 S ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/