Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cursor Adapter is the way to go?
Message
De
01/06/2007 04:49:55
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01229649
Message ID:
01229750
Vues:
10
>The way I did it:
>1. When you create your .dbf's, make sure the sturcture will work in SQL Server too. (For example, no date fields, no time fields, use only datetime fields)
>2. Make another DBC and put nothing but remote views in it to connect to your DBF's. You'll want to use remote views for your entire application.
>3. Upsize your dbf's to SQL Server. (If you designed them correctly, NO structure changes will need to be made).
>4. Now, if you want to use SQL Server instead of DBF's, all you have to do is change the connection string in the .dbc with the remote views to point to the SQL Server instead of the .dbc with the tables in it.
>
>This is really a pretty cool way to do it. To change from DBF's to SQL Server you dont even have to recompile.

There're a lot of things he should to learn... I remembered I could found server lock problem about of fetching issue in a week.... :(
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform