It's always been my understanding that the single quotes don't work at ECL/TCL. I'd try the same thing but use double quotes instead.
Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 08/29/2006 09:53:33 AM: > We have a file that has the customer number and invoice date indexed. > When we execute at TCL "SELECT ORDERS WITH CUST.NO = '12345' AND > WITH INV.DATE = '12/14/05'" no items are selected. > We are running Unidata 6.0.6. > Is anyone aware of any issues ? > [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/