I never used this feature of DBISAM before.

I have tried it on DBISAM 4.25 in a TDBISAMTable and I found out that it requires exclusive open for the table.

I need to create an on-the-fly index for data presentation, and after that the index will be deleted.

I know that I could be using a SQL, however I have the application already using the Table component and I need to create a new index according the user need to navigate the data.

However the application is in a multiuser enviroment and there is no way to have exclusive open access to the table.

Is there a solution for that?

Thank you

Eduardo

>I need to create an on-the-fly index for data presentation, and after that the index will be deleted.
>
>I know that I could be using a SQL, however I have the application already using the Table component and I need to create a new index according the user need to navigate the data.
>
>However the application is in a multiuser enviroment and there is no way to have exclusive open access to the table.
>
>Is there a solution for that?

Quick answer: NO

You have three choices:

1. use SQL
2. get everyone off that table
3. create a temporary table and use that

That's no better than 1 in my view but since you're already using a table component it might be the easiest option.

Roy Lambert [Team Elevate]

On 12/9/2013 5:54 AM, Eduardo wrote:
> I need to create an on-the-fly index for data presentation, and after that the index will be deleted.

In addition to what Roy said:

Any reason not to make the index permanent ? Unless you index changes
all the time the cost of having an extra index is negligible relative to
adding/dropping an index.

Raul