Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The AS clasue in a Remote View with Table Update
Message
 
To
11/12/1999 18:00:27
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00302292
Message ID:
00302314
Views:
24
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform