Stuart,
>I have made some progress with mySQL and it now seems to work as long as I do not set this.RetrieveAutoIncrementPK = true; then I get the following error
>
>FUNCTION tp.SCOPE_IDENTITY does not exist
>
Very groovy! If you have subclassed your mySql data access class from mmDataAccessSql then you need to override the ConfigureInsertForAutoIncrement() method with code that can be used to retrieve the newly generated primary key from mySql. A quick Google search turned this up for MySql:
mysql_insert_id()
Here's the link where I found this:
http://dev.mysql.com/doc/refman/5.0/en/mysql-insert-id.htmlBest 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