mySqlUpdateCommand1

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
wdavet
Posts: 24
Joined: Mon 26 Feb 2007 16:57

mySqlUpdateCommand1

Post by wdavet » Tue 19 Feb 2008 15:24

In the most recent release of you MySQL Direct Product I noticed something that is inconsistent.

the this.mySqlUpdateCommand1.CommandText get it's text from resources in the class like this

//
// mySqlUpdateCommand1
//
this.mySqlUpdateCommand1.CommandText = resources.GetString("mySqlUpdateCommand1.CommandText");

All other commands like this.mySqlInsertCommand1.CommandText explicitly get the command text via a generated string like

//
// mySqlInsertCommand1
//
this.mySqlInsertCommand1.CommandText = "INSERT INTO dontjoinmilitary.members (MEMBERID, SIGUPDATE, FIRSTNAME, LASTNAME, E" +
"MAIL, USERNAME, PASSWORD) VALUES (:MEMBERID, :SIGUPDATE, :FIRSTNAME, :LASTNAME, " +
":EMAIL, :USERNAME, :_PASSWORD)";

This causes a problem in ASP.NET component designer since it appears not to have the same resources scheme as windows forms classes.

If you will update to explicitly input the command string for the mySqlUpdateCommand I think it will solve this issue.

Sincerely,

W. David Taylor

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Thu 21 Feb 2008 11:02

Hello David,

Please send me a small test project to reproduce the problem.
It is desirable to use 'test' schema objects, otherwise include the
definition of your own database objects.
Do not use third party components.
If it is impossible for you to create the test project, send us a piece of
your code where the error occurs.
We will investigate this issue.

Post Reply