>I got an error message when I tried to run a form during development. It said I needed to delete the CDX and recreate it for the file. Deleting, no problem, I can handle that... recreating, problem how?
>
>There were 5 indexes for various fields in the file. I ended up having to run VALIDATE DATABASES RECOVER (as prompted) and then had to manual put the indexes BACK in the database in the PROJECT. There has to be a better way.
I found this to be a problem and worse it was a problem in the field. The users would lock their machines up and shut them off ( normal because in most cases that was the only thing they could do ). Every once in a while this would foul the index and I would get a call and have to recreate them. I solved this problem by throwing a reasnable amount of money at it. I purchased Stonefield's Database Tool kit. It keeps track of the index definitions in seperate tables. If an index fails ( or you update tables or indexes ) it can recreate/update them. It always recreates indexes from scratch so no bloat occurs. All changes to the data structure are automatically updated. I have the function check the modification dates on the dbc dbx files and auto update on change. The test is performed each time the applicatio is started.
This is only the tip of the iceberg of what SDT does for you. I find the product to be WELL worth the money @ $300.
Hope this helps
Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.
MCP( Tcp/Ip )