Bug fixed details wanted

Bug fixed details wanted

Postby Amish » Fri 18 Jan 2008 07:59

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
Amish
 
Posts: 20
Joined: Thu 05 Apr 2007 12:04
Location: INDIA

Postby Alexey.mdr » Fri 18 Jan 2008 11:18

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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Re: Bug fixed details wanted (forum="MyDirect .NET")

Postby Amish » Mon 21 Jan 2008 08:52

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
Amish
 
Posts: 20
Joined: Thu 05 Apr 2007 12:04
Location: INDIA

Postby Alexey.mdr » Mon 21 Jan 2008 09:41

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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Re: Bug fixed details wanted (forum="MyDirect .NET")

Postby Amish » Mon 21 Jan 2008 10:52

Thanks for the suggestions.

I will try reconfiguring my server (MySQl 5.0)

Thanks,
Amish
Amish
 
Posts: 20
Joined: Thu 05 Apr 2007 12:04
Location: INDIA


Return to dotConnect for MySQL