>I assume that this has something to do with not being able to determine the primary key so that it knows which record(s) to update or delete. I can't figure out how to set the primary key. I managed to set it up in the DataSet, but that seems to have no effect on the DataAdapter.
I'm fighting this one right now too. I don't think VFP supports sending schema information so you won't get automatic update/insert statements. I'm surprised you get an INSERT statement - i don't see that. I've also tried FillSchema() of the DataAdapter but still doesn't work.
You can manually set those commands, but I can't even get that to work either. All updates/inserts are failing on my end with 'Cannot update cursor'. Same works with SQL data and the SQL Update works fine when run from VFP.
Has anybody gotten this to work?