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