Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Web Service
Message
From
14/02/2006 20:25:43
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Web Service
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01096380
Message ID:
01096380
Views:
45
I am just finally starting to work with Mere Mortal and have started on a web service and everything is working fine for retrieving data. That was easy as pie.

However I need to be able to update or insert records from a fox app that is installed in remote offices. Currently we are using FTP to copy the data to the server and then another process runs to insert/update the records. It currently works ok the way it is but you know how that goes.

I would like to add a insert and update method to this web service but cant seem to get my mind around it.

1. Client software retrieves a data set of New customers and another data set of updated customers from fox application.

2. Client Calls webservice update Customers and Insert Customers method on web service.

3. Data is then loaded into SQLServer. (The Sql tables have the same structure as the Fox tables.)

4. Result is passed back to client.

Below is code that I am trying but it returns save canceled. Any help would be appreciated.
 <WebMethod()> _
    Public Function UpdateCustomer(ByVal DSNew As DataSet) As String
        Dim nResult As OakLeaf.MM.Main.Business.mmSaveDataResult
        Dim OCustomer As New customerBusObj
        Try
            nResult = OCustomer.SaveDataSet(DSNew)
        Catch ex As Exception
            nResult = ex.Message
        End Try

        Return nResult
    End Function
Next
Reply
Map
View

Click here to load this message in the networking platform