If the indexes are deleted, the select statement works fine. Kevin King <[EMAIL PROTECTED]> wrote: >When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND WITH INV.DATE = '12/14/05'" no items are selected.
And if you disable the index (via DISABLE.INDEX) the select works fine? And is the customer number and invoice date both in the ORDERS file? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ --------------------------------- All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
