General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>All,
>
>We can use SQl remote view or SQL "Pass through" to update SQL Database.
>But which one is the better solution?
>
>Ricky
It depends on what church you go to. Some people would rather use VB than use remote views. Others make good use of them.
My question would be, how did you GET the data in the first place. If you are usinging SPT to get your data, then using SPT to update it may be the best choice.
Another thing to consider is, if you are using client side SQL (code) then you may want to consider using ADO which supports the more current data access OLE-DB providers.
Finally, once you decide you also need to decide HOW to send updates to the database. With SQL Server, you can also send XML Update/Diffgrams rather than the traditional insert/update/delete commands. These are easy to generate in VFP 7.0 using the XMLUpdateGram() function.
I guess this all brings us to the answer of 'it depends'.
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only