>I am trying to do something I think should be simple. I have a Remote Connetion to a SQL Server 2000 DB table and I'm trying to update three fields in it from info located in a VFP table.
>
>What I am doing is selecting all the records from the VFP table that need to be updated in the SQL table. Once I have that resultset (cursor) I select it and start scanning though it as below:
>
>SELECT c_PaidInvoices
>LOCATE
>SCAN ALL
> UPDATE tblSales ;
> SET dtepaid = c_PaidInvoices.dtepaid, ;
> paid = .T. ;
> WHERE invno = c_PaidInvoices.invno
>ENDSCAN
>
>It seems simple enough to me but at some point I start to get an "Update Conflict (Error 1585)". I suspend the program and do a "= TABLEUPDATE(.t., .t.)" which works. But now I am getting a "Function Requires Row or Table Buffering mode (Error 1586)" Buffering is set to 3. The UPDATE statement will update more than one record since each invoice can have multiple lines. I'm not sure if that is an issue. The key fields for the tblSales view are the invno and line_no fields. In the "Connection Designer" under "Data Processing" the Batch Processing and Automatic transactions are checked.
>
>In the "View Designer" for tblSales the Update Criteria has the "Send SQL Updates" checked and all fields selected to be updated. The key fields are invno and line_no. "Update using" is set to "SQL UPDATE"
>
>Does anyone have any suggestions on what I need to do to resolve this problem?
>
>Thanks in advance,
>John Gundrum
Anthony,
I am having a similar issue myself. Did you ever get any resolution on this?