Wanted to change the name of a column, told not allowed to drop because its in a full text index. Added new column went to full text index, altered the column, clicked OK and got
---------------------------
ElevateDB Manager
---------------------------
Invalid pointer operation.
---------------------------
OK  
---------------------------

Any attempt to do things to the index after that

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #300 Cannot lock the table TfRManual for exclusive access.
---------------------------
OK  
---------------------------


Roy Lambert

Roy,

<< Wanted to change the name of a column, told not allowed to drop because
its in a full text index. Added new column went to full text index, altered
the column, clicked OK and got >>

I can't replicate this one either.  Could you be more specific, such as
after you get the drop message, do you stay in the Alter Table dialog, or do
you exit and re-enter it ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


From memory

1. Enter alter table dialog
2. Try to alter column - not allowed
3. Add new column
4. Exit alter table dialog
5. Open the alter index dialog
6. Alter the column from _Text to _Detail
7. Click OK

woops

Roy Lambert

Roy,

<< From memory

1. Enter alter table dialog
2. Try to alter column - not allowed
3. Add new column
4. Exit alter table dialog
5. Open the alter index dialog
6. Alter the column from _Text to _Detail
7. Click OK >>

I still can't reproduce this.  Two questions, however:

1) Does this FTI use a custom word generator and/or text filter ?
2) Can you send me the database catalog and relevant table files so that I
can try with the "real deal" here ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


>I still can't reproduce this. Two questions, however:
>
>1) Does this FTI use a custom word generator and/or text filter ?

Yes to both (they're the ones in the extensions ng)

>2) Can you send me the database catalog and relevant table files so that I
>can try with the "real deal" here ?

Unfortunately not. The tables I was playing with were the ones I was going to use for on line help and I decided to use SQLite for it so they got zapped.

Roy Lambert