PDA

View Full Version : A bug displaying fields with indexes



John Engleman
3-May-2005, 10:47 AM
I discovered a bug displaying fields from a table when one of the fields is
indexed.

I have two tables: Master1 and Master2

Master1 has Field1 Field2 Field3 Field4 etc
Master2 has Field1 FieldA FieldB FieldC etc

Master2 Field1 is linked to Master1 Field1

Master1 has several indexes 1 = Field1, 2 = two other fields, 3 =
someother fields, 4 = Field1 & Field2

The problem comes in when using Master1.Field1 to load the information to a
webpage & wso based on Master2.

The page for Master2 contains mostly fields from Master2 but Master1.Field1,
Master1.Field2 & Master1.Field3 are also displayed

After the page loads empty, you then try to locate a record based on
Master1.Field1. All the data displays except for Master1.Field2. If you
display the next or previous record, the field fills in and displays
correctly from then on. Master1.Field1 displays properly because it was
manually entered. I also noticed that if I changed Master2.Field2 to
someother Master1.field on the web page, it displayed properly, so it has to
be the index causing the problem

I corrected the problem by removing Index 4 from Master1. The problem
re-appears by recreating any index on that field.