Devart Forums

Hiii There,

I wanted to know some details about MyDirect.Net 4.25.21

You have described in newer version bug fix i.e. Mydirect.Net 4.25.22 =
that

"Fixed bug with MySqlCommandBuilder generating empty INSERT statements "

Can you explain this in detail ?

This is because i am having bugs in my project with multiple data.

Thanks in advance.

Amish

The bug was:
if using the RefreshMode = Both then a “SELECT” word was wrongly added to the UpdateCommand.CommandText and InsertCommand.CommandText.

Could you specify the errors that you got?
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.

Hi..

I was having duplication of a data in mysql database.
More Surprisingly,The data was to be stored in primary key field.
So the Problem was,two primary key field with same value.

How is it possible????

Might it be arised due to this bug?

Moreover,This was not occured every time.It was not certain error.It was
being arised randomly.

Thanks
Amish

The bug is not connected with this odd problem. A database itself manages primary keys. That means that it doesn't depend on any software that you use, but on a database only. If you try to add duplicated primary keys, your program will successfully send such query (because generally an application doesn't know the primary key values in a database). But a database will not add the row, throwing an exception. The message would be something like “An INSERT command failed because a row with such PRIMARY KEY already exists”.

As you say the problem appears from time to time, I reckon, the problem is in the server. Try to install a newer version of the server.

Or, if it is possible, 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 please. If it’s not possible for you to create the test project, send us a piece of your code where the error occurs.

Thanks for the suggestions.

I will try reconfiguring my server (MySQl 5.0)

Thanks,
Amish