Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
Dynamically creating an Index |
Mon, Dec 9 2013 5:54 AM | Permanent Link |
Eduardo | 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 |
Mon, Dec 9 2013 6:04 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Mon, Dec 9 2013 9:06 AM | Permanent Link |
Raul 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |