Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View on a SQL Server View not updating base table
Message
 
À
26/04/2006 15:24:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Database:
MS SQL Server
Divers
Thread ID:
01116667
Message ID:
01117305
Vues:
12
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform