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
= 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:
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
SQLString: ALTER TABLE indokpos ADD COLUMN ID_ART CHAR( 6 ) DROP KATALOSKA
Subject: Alter table structure when index is present
Date: Thu, 25 Oct 2007 09:41:51 +0200
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
X-Trace: 25 Oct 2007 01:37:42 -0700, 188.8.131.52
Xref: solutions.advantagedatabase.com Advantage.Xbase++:841
Article PK: 1140709