Hello,

The SQL engine return below error, when I want to drop a field, that is
present in on of tables compound index tags.

What would be the easiest approach to overcome that problem ?

Namely, if that error is unavoidable, I need to read every table index
structure, examine all tag structures, compare to the droped field name,
delete a tag or enitre index and then rebuild it again.
Also I have to know, what index structure was before, without that
particular field, to rebuild it.

A lot of work. Is there any easiet way, maybe stored procedure?

ARC droped the field to me without any problem, although the index was
present.

Best regards

Toma?

= SQL ERROR ===========
Date: 20071025 09:08:08
C:\_PIS\PISADS.EXE, Thread: 1
Windows XP 05.01 Build 02600 Service Pack 2, SQLXpp: 3.1.24, Runtime:
1.90.331
SQLState: HY000, ErrorCode:7200
[Extended Systems][Advantage SQL][ASA] Error 7200: AQE Error: State =
HY000; NativeError = 5152; [Extended Systems][Advantage SQL][ASA] Error
5152: The table restructure failed. The restructure may not proceed
because the field to be deleted named "KATALOSKA" is used by an index named
"KARTICA".

SQLString: ALTER TABLE indokpos ADD COLUMN ID_ART CHAR( 6 ) DROP KATALOSKA