Yassin,
>I have a very simple Business object that reads, write,delete and selects from a single table. When I try to delete a record I get
>Concurrency violation: the DeleteCommand affected 0 of the expected 1 records.
Can you describe what your form is doing? It seems unusual to get a concurrency violation when deleting. It looks like you are using an mmButtonDelete instance on your form. Have you specified a primary business object on your form or have you set the button's BindingSource property?
Best 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