Subject | Index unexpectedly deleted ??? |
---|---|
Author | Marcin Bury |
Post date | 2002-05-07T09:12:16Z |
Hi list
I have changed the order of the fields in one index. The index still exists
under the same name. After these changes I cannot add new record, trying to
post I'm getting this error:
Index unexpectedly deleted
table : mgp_pz (pz_id integer, srv varchar(3), arch integer, ....
original index was : srv, arch, pz_id
and I have changed to arch, srv, pz_id
primary key is srv, pz_id
Tested with Firebird 1.0.0.679 (RC2) and IB_SQL
Any solutions?
TIA
Marcin
I have changed the order of the fields in one index. The index still exists
under the same name. After these changes I cannot add new record, trying to
post I'm getting this error:
Index unexpectedly deleted
table : mgp_pz (pz_id integer, srv varchar(3), arch integer, ....
original index was : srv, arch, pz_id
and I have changed to arch, srv, pz_id
primary key is srv, pz_id
Tested with Firebird 1.0.0.679 (RC2) and IB_SQL
Any solutions?
TIA
Marcin