As you noted, records will no longer be lost in VFP8, especially with SP1.
But I just want to mention a couple of things:
1) The described situation is not necessarily the only one that causes loss of data. Rather, it *may* be the only one for which a reproducible situation could be achieved.
So it is possible that other losses of records have been addressed by the fix now available.
2) Someone, way back, had described some lengthy dialogue with MS Support on the problem and had found that ensuring that a table had 2 "dummy" fields at the very start, one I and one C(10) when the first field otherwise was an I PK, the incidence of loss went way way down.
cheers
>It was row buffering. But I don't think had any influence. The bug is documented here:
>
http://support.microsoft.com/?kbid=293638>
>Dorin.
>
>
>>Do you use buffering within transactions ?
>>
>>Walter,
>>
>>
>>>I use transactions. If you are lucky enough and tables are not corrupted, is OK. Otherwise, you have to handle the BEGIN/END TRANSACTION bug. All inserted records dissapear (I've seen that was fixed in VFP8 though).
>>>If you never had index corruption then you are very lucky.
>>>We even had a "delayed write" error that had as result a 50 MB table filled with chr(0). Because some bug in windows network client.
>>>
>>>>Depends on how you write your programs. Use buffering and transactions as much as possible to minimize the problem. In my ten years of developing and maintaining about two dozen VFP apps I never had a clear index corruption while several hundreds of user are using those apps each day. I remember the index corruption problems mostly from the FPW 2.x days when doing things over an unreliable WAN.
>>>
>>>I would vote for VFP + Firebird, but I'm subjective here :-)
>>>
>>>>
>>>>Other difficulties that come with MSDE.
>>>>
>>>>- More difficult to install
>>>>- More difficult to maintain.
>>>>- More suspectible to mallfunction or virusses.
>>>>- MSDE: a Data limit or 2.1? GB
>>>>
>>>>All with all a good reason to evaluate what you need before you decide whether to use a pure VFP solution or a combination of VFP and MSDE.
>>>>
>>>>Walter,
