Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The AS clasue in a Remote View with Table Update
Message
From
23/12/1999 13:51:45
 
 
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:
00308110
Views:
30
>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?
>

You just need to make sure that the update name property of the view reflects the name of the field in the remote database. You can set this property using DBSETPROP, or more easily with eView. (you can get eView here in the files section).
Erik Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform