Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update SQL Express Table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01415993
Message ID:
01416000
Vues:
48
>Thanks Naomi for the quick reply. I was able to open the view with no problems. I tried using SQLExec() and REPLACE FMS_Processed WITH .T. It didn't seem to work. I didn't try UPDATE. Since I have have to get up early tomorrow, I closed up my computer. I'll try it then. From what I read, I must first set the remote table as updatable with CURSORSETPROP() commands. I guess I then could use VFP code or do I still have to use SQLExec()?
>
>Thanks,
>
>Bill Todoro

I believe you can use VFP code and TABLEUPDATE to write changes back to SQL Server. I don't have much experience with Remote Views, I prefer using Cursor Adapter.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform