Neil,
>I am using the newest vfp that has the autoincement column. I tried to use the vfp autoincrement int to simulate the sql Identity columns. I am still getting an operator/operand error. Might the problem be in the oledb data provider for vfp? Do we have to create custom data classes?
I just checked this out and I see the problem you're experiencing. It's definitely an issue with the VFP OLEDB Provider. I need to check further into this for a solution...I'll get back to you on it!
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com