Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What are the main issues involved in VFP6 + SQL7
Message
De
24/01/2003 13:26:58
 
 
À
24/01/2003 13:22:31
Diptesh Patel
Unitelsoftware Ltd.
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00745173
Message ID:
00745177
Vues:
24
All the problems you mention are not normal.

a. See http://www.craigberntson.com/Articles/kb005.htm on my web site for ideas.

b. Can you elaborate on that?

c. Difficult to say what's causing the child/master problem, but most likely it's due to application design, not VFP itself.

>Hi,
>
>We have decided to change VFP native database to SQL server database for following reasons.
>
>a. VFP database (index) gets currputed. (Is there any virus which is doing so?). Duplicate records getting saved in presence of PrimaryKey!
>
>b. Non consistency in data saving.
>
>c. Poor handling of transaction. Data is getting saved in child and not in master. Record locking issue in Multiuser environment.
>
>
>1. What are the issues involved?
>
>2. What is the best architacture available (for VFP + SQL)
>
>3. Any Samples?
>
>
>TIA
>
>Diptesh
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform