Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
The AS clasue in a Remote View with Table Update
Message
 
À
11/12/1999 18:00:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00302292
Message ID:
00302314
Vues:
25
>I am going to be using remote views against sql server data and desire to utilize the AS clause, ie Select "Field1" AS "FieldOne".
>
>Subsequently I will be updating the backend server data from this view. I am wondering if this will be problematic? That is to say, will the remote view negotiate the update to the original fieldname or attempt to update data on the backend using the fieldname desgnated by the AS clause?
>
>Thanks

Barry,

It should work fine, but it takes very little to try it out. You can connect to VFP data as remote data. Simply set up the VFP ODBC driver as an ODBC dtaa source and then create a remote view using that data source.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform