You're setting NO.NULLS on that field, could this be your problem. By the way, what are you using for your email? You can hardly read the message with all of the =0D=0A codes in it.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Franklin Sent: Wednesday, August 02, 2006 3:49 AM To: u2-users@listserver.u2ug.org Subject: [U2] Index files We are running UniVerse 10.1.7 and use indexing on a number of files.=0D=0A Randomly on one of the files we keep loosing the index on the same=0D=0A field, PHYS.PALLET.ID.=0D=0A =0D=0A =0D=0A =0D=0A Index name Type Build Nulls In DICT S/M Just Unique Field=0D=0A num/I-type=0D=0A =0D=0A =0D=0A =0D=0A PHYS.PALLET.ID D Not Reqd No Yes S L N 6=0D=0A =0D=0A TRUCK.ID D Not Reqd No Yes S L N 8=0D=0A =0D=0A ORDER.NO D Not Reqd No Yes M R N 1=0D=0A =0D=0A WAYBILL.UMC D Not Reqd No Yes S R N 9=0D=0A =0D=0A WAYBILL D Not Reqd No Yes S L N 14=0D=0A =0D=0A =0D=0A =0D=0A So SELECTINDEX fails, has anyone experienced similar problems. The data=0D= =0A in the fields is always of the form 4A4N and there is a one to one=0D=0A relationship between the field and the primary key.=0D=0A =0D=0A =0D=0A =0D=0A Regards,=0D=0A =0D=0A Tim=0D=0A =0D=0A =0D=0A Legal Disclaimer:=0A The information contained in this message may be privileged and confident= ial. It is intended to be read only by the individual or entity to whom i= t is addressed or by their designee. If the reader of this message is not= the intended recipient, you are on notice that any distribution of this = message, in any form, is strictly prohibited. If you have received this m= essage in error, please immediately notify the sender and delete or destr= oy any copy of this message=0D=0A ------- 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/