View Incident Report

Serious

Reported By: Ralf Bieber
Reported On: 1/2/2005
For: Version 4.15 Build 1

# 1933 Deleting a Text-Indexed Column Using ALTER TABLE Statement Can Cause Error

Deleting a column from table structure, if the field is in TEXT INDEX, doesn't work properly with ALTER TABLE. The error:

DBISAM Engine Error # 10023 Invalid field number 'XX' specified in the index 'SYS Text' for the Table

occurs.

Existing:

TEXT INDEX ("Artikelnummer","Name","Name1",
 "Verbreitungsgebiet","Standort",
 "Ansprueche","PhWert")

and run the SQL-Script:

ALTER TABLE Artikel TEXT INDEX (Artikelnummer, Name, Name1) 

In the *.IDX Table the TEXT INDEX field count is correct,
but the pointer of the removed fields are not deleted.

Resolution

Fixed Problem on 1/2/2005 in version 4.16 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap