>I have always been very careful that all connections are OK, and I always use UPS. And one last, important thing is that I always make sure that my index keys give a fixed length value. And by the way, if you unplug a SQL server in the middle of a transaction, I guess it also will cause some strange behavior.

I have users some of vfp+dbf some of fpd+dbf and some of vfp+sql server. My sql server users never met data corruptions even power failures (ups failures).
There are a lot of reasons for index and data corruptions. I see best solution is use vfp with sqlserver. dbf files are trouble every time...

When I was using foxpro dos + novell with netware.plb, my customers wasn't see data or index problems. Netware.plb was an excellent library...