It makes perfect sense to look at the data adapter but I don't know how to hook into it and view what is being transmitted. Where would you do it and how? What class, etc. It would be a terrific skill to master since I continue to struggle with the lack of adpater wizard support for vfp.

Neil

>Sorry, Neil... nothing's jumping out at me. Don't have much experience w/oledbprovider, tho' so it may be obvious and still going right by me.
>
>I have a feeling your best bet is to see the exact command string being sent to VFP through the data adapter.
>
>---J
>
>
>>Thank you. I do however have a little more info about this syntax error. I changed the structure of the data file to avoid using auto-incrementing integer unique field. Now my unique field is a Character field.
>>Guess what? Same syntax error. Please review my customdataclass and see if my code is up to stuff.
>>
>>Regards,
>>Neil