Stuart,

>I am once again having a go at using MySQL as a back end. I can now query MySQL but I cannot add a record. It fails at
>

>IDbCommand cb = this.CommandBuilder.GetInsertCommand();
>
>
>And I get the error
>
>
>Dynamic SQL generation is not supported against a SelectCommand that does not return any base table
>

>
>Any ideas?

Which .NET Data Provider are you using to access MySql?

Best Regards,