My problem seems to be that Unidata see's the A and thinks I am doing a alphanumeric search on everything after the A. It takes the A as a command to do an alphanumeric search. I was told you could put quotes around the criteria to get it to work right but so far I have not been able to do that.
Daniel Knutson OSTech Client Support www.epicor.com Tel.: (800) 347-2381 Fax: (800) 764-4539 E-Mail: [EMAIL PROTECTED] 600 South HWY 169 2000 Interchange Tower, Minneapolis, MN 55426 This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Friday, March 11, 2005 2:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Indexing issue Not necessarily so... An index on the primary key will not only allow you to sort or sselect the file by that key instantly, but also allow quick selects on partial keys (e.g. select myfile with key = 12345]). Admittedly esoteric, but on occasion handy. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Friday, March 11, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/