>hi all,
>
>I'm gonna create a form which allow users to edit the content of MyTable.
>MyTable has an index file MyIndex
>
>But in my case the setting of MyIndex does not suit my requirement, at the same time I can never change the structure of the table or the index.
>
>So, at the load event of my form, I create a temp index file (TempIndex) for MyTable, do the job, and then delete it at the MyForm.unload event.
>
>My question is, since users can change the content of MyTable, do I need to update the original index file (MyIndex) as well, in order to make sure any other programs wouldn't have problems when they use the files? And how? Any idea or suggestions are greatly welcomed!
>
>Jimi
Is your temporary index an IDX or a CDX? I had some nasty problems that bit me a while back using a temporary IDX, and will never use them again! Tableupdate failed when I had an IDX for the table in a different private datasession.
IAC, this may be more of a change than you want to make right now, but I'd use an updateable view for this. You can create a CDX tag on the view.