Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How 2 - VFP update 2 SQL
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
VB.NET 1.1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Divers
Thread ID:
01003344
Message ID:
01004458
Vues:
18
>This is a new application which is both for production and as a test of the usefulness of .Net. I have been experimenting with MM.Net and hope to use the framework for this application. My initial thoughts were to use a VFP COM server to prepare the data forr further processing on the WEB server. Store VFP generated XML to Datasets and then use MM.Net to safely tuck them away on SQL Server where a stored procedure would "digest" the VFP data.
>
>I would appreciate any comments or "Best Practices" recommendations for this application. We are VERY serious about adopting MM.Net for future development and integration into our flagship product, and I need to develop adequate skills to promote .Net interop.

You said the VFP desktop app prepares a batch of inventory updates. Where is it getting the inventory update information from? Are FoxPro tables involved in the mix? It sounds like you're thinking of converting cursors to XML and passing them to a web server running a .NET Web Service which would in turn write the updates to SQL Server?

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform