>A long time ago, I developed a data entry system with VFP-5-DOS.
Hmmm... some sort of magician? There was never a VFP 5 DOS. Perhaps you mean 2.5?
>The indexes were so fragile that I had to reindex everything each time the user started the system and I added a global reindex facility for use when the indexes became corrupted during data entry.
Ummm... I hate to tell you this, but that was due mostly to applcation design and bad user habits. I had more problems with 2.x indeces than I've ever had with VFP, but through the use of views and buffering, in addition to users learning to shutdown applications before turning off their PC.
>
>For most of the last decade, I've been using VFP as a data engine for data warehouse apps. Data uploads were so large that I routinely dropped the indexes, added new data and reindexed the tables. Therefore, index corruption was not an issue.
>
>I'm looking at a client that wants to develop a new n-tier app using VFP as the business tier and the data tier. The initial interface tier will be VFP, but the client wants to be able to add a web interface at a later date.
>
>I'm concerned about the fragility of VFP-9 indexes and am considering advising the client to move to a SQL Server data engine. For the size of the database, the app would be better served with the VFP engine, but my (ancient) experience makes me leary of VFP's indexes.
SQL Server may very well be a better solution, but without more details of your need, I can't say one way or the other. Many people are using VFP for web apps without problems.
>
>Regards,
>Thom C.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer