Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View on a SQL Server View not updating base table
Message
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 6 SP5
Database:
MS SQL Server
Miscellaneous
Thread ID:
01116667
Message ID:
01117305
Views:
13
Thanks Fred. That loud, yet hollow, sound you hear is my forehead bashing against the monitor. :-)

Nothing like missing the forest for the trees :-0

>>Using VFP6 SP5 and SQL Server 2000.
>>
>>I have a SQL Server view of 2 tables. If I issue an UPDATE against the view using SPT, the base table data is updated as well.
>>
>>If I create a remote view of the SQL view and update some data, TABLEUPDATE(1) returns .T., however, neither the SQL view or table have actually been updated. I determined this by issuing a SELECT ... against the table and view using SPT.
>>
>>Does anyone know why the data is not updating and what I can do to accomplish this?
>
>Did you check "Send SQL updates" when you created the view?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform