Stuart,
>I have already overridden that with
>
> return insertCommand += " ; Select LAST_INSERT_ID() AS " + this.PrimaryKeyName;
>
>so not sure where to go now.
>cheers
>no doubt I will get to the bottom of it eventually, any other ideas gratefully received
I'm guessing the actual error is occurring further along in the data access class...have you tried setting the UpdatedRowSource property to None as specified in the error message? You can do this in the data access class.
">When MySqlCommandBuilder.ReturnGeneratedIdentifiers is true,
>MySqlCommand.UpdatedRowSource must be set to None.
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