Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update SQL Express Table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01415993
Message ID:
01416000
Views:
51
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform