>I created a simple CA for a Simple table. I can get that to work (insert/update/delete) this works just fine, however, when add code for my larger table (only things that have changed are the insertcmd, updatecmd and schema), i get the following: "Microsoft OLE DB Provider for Visual FoxPro : Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done." I know the Schema is correct because it's the same schema i use for ODBC. The rest of the CA is identical to the simple CA i created and works.
>
>Any clue anyone. BTW, I am running VFP8 SP1
>
>Mark


Hi Mark,

What operation fails?
First thing I would try to find out what is wrong is to not use schema for CursorFill and let CursorAdapter to generate commands automatically instead of providing custom commands.

One more thing. If you post your code and schema for the table here, it will REALLY speed up the process.

Thanks,
Aleksey.