Hi All this arrived from Elie at xCase
We have also (almost) completed the development for InterBase 6 and have
also added support for Triggers on Views. We are still waiting for InterBase
to provide a stable ODBC driver for 6. Also we seem to have finally tracked
down the "Index is in use" problem.
Here is a transcript of the message we sent to InterBase:
We keep on receiving complains from our users on the "Index is in Use"
issue.
After doing a lot of research on this very annoying matter here are our
findings:
When we create a Foreign Key constraint with Declarative RI, InterBase
automatically builds an Index on the Foreign Key.
There seem to be quite a few situations when this index is "used" by
InterBase. For example when you modify the table by creating this Foreign
Key constraint. We have not identified all the cases, but when they happen,
InterBase will not let you drop the FK constraint and says that "Index is in
use".
Currently the only solution we now in order to delete this Foreign Key is to
disconnect from the database and then connect again but you have to be very
careful not to "lock" the index again.
This is extremely annoying because as you now, InterBase does not
automatically handle dependencies. When an object need to be modified, xCase
analyses the dependencies and often generates a script that includes
statements that attempt to drop Foreign Keys. When the scripts fails in the
middle it causes a lot of trouble.
We need a solution or at least a Work Around for this problem that according
to various forums is shared by many InterBase users.
Disconnecting and reconnecting each time such a statement is submitted, is
to say the least, inelegant. It is not possible to drop the Index that
InterBase builds on the Foreign key. Also as I said we are not clear when
exactly InterBase "locks" the Index.
Regards Neven
N.K. MacEwan B.E. E&E
[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
