Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP & SQL Compact Edition
Message
De
23/12/2010 13:48:41
 
 
À
23/12/2010 13:36:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server CE
Application:
Desktop
Divers
Thread ID:
01493672
Message ID:
01493735
Vues:
86
>Thank you for this confirmation. It looks like for some people it's much easier to blame VFP than realizing that they need to focus on finding the reason for their problems.
>
>>You keep talking about corruption with VFP tables. It's not due to the tables, but due to one of two problems:
>>
>>1) Poor application architecture. Using direct access to the tables increases the possibility of data corruption. But architecting your application to use less direct methods and use of the FLUSH command solves these problems.
>>
>>2) External issues. These are mostly out of your control. Bad routers, frequent power interruptions, and other issues can cause corruption. One additional thing here. If you have poor application architecture, users turning off the computer or killing your application through task manager can also cause corruption issues.
>>
>>Moving to SQL Server is not a solution. It's simply putting a band-aid over existing problems.

But it's a pretty efficient band-aid for your issue #2

>>>Has anyone used sql ce. Is there any help available on this topic.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform