Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
ktroxel@my-deja.com — — source: Informix-list mailing list archive (1991-1998)
I a little stumped. We're running 7.30.UC5 on a Sun E/4000. I've
written a small 4gl program that updates (changes) the value of a field
that is part of a unique index on the table. Everything appears to run
fine. But if I go back in and run a select on the new value, it
returns no rows. To make matters worse, if I run a select choosing the
old value in the where clause, it returns the row, but the row show's
the new value (not the value in my where clause).
OK - so now it's obvious that my data and index are out of sync. If I
drop/create the index everything is wonderful. My question is how can
this get out of sync so easily - it's a little un-nerving. Before
dropping the index I ran oncheck on the tablespace data rows and
indexes - showing no problems.
Any clues out there. Thanks in advance.
Ken Troxel
ktroxel@cosc.maricopa.gov
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.