Problems with DataSet & AutoIncrement

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Problems with DataSet & AutoIncrement

Post by Zero-G. » Thu 25 Sep 2008 11:30

Hey
I use your latest building of v4 (4.5.85)

When I add a DataSet through the Wizard to my project (With DataAdapters) then it seems to work fine.
DataAdapter.Fill(DataSet) - WORKS
DataAdapter.Update(DataSet) - WORKS

But, when I change one column to AutoIncrement=True, AutoIncrementSeed=-1, AutoIncrementStep=-1 then
DataAdapter.Fill(DataSet) - Works
DataAdapter.Update(DataSet) - Don't work!
By checking out the reason, I found out, that DataSet.GetChanges = NOTHING

Any ideas!?

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 26 Sep 2008 10:50

Please provide us (alexsh at devart.com) with a small test project. It will help us to investigate the problem.

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Fri 26 Sep 2008 11:21

I have send you a sample project.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 29 Sep 2008 12:00

Try setting the AutoIncrementSeed property to "0", not "-1". The "-1" value is recognized as .

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Wed 08 Oct 2008 11:26

Hey

I have send you a sample project, where still are errors!

THX

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 08 Oct 2008 13:31

Thank you for the bug report. We are investigating this problem.

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Tue 14 Oct 2008 14:22

Hey

Do you have some news for me, when this problem will be fixed!?

THX

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Wed 15 Oct 2008 11:39

As we told you in the letter, the problem is associated with Microsoft's components, and it is rather complicated. Unfortunately, no time frame can be provided.

Zero-G.
Posts: 398
Joined: Sat 09 Dec 2006 12:20

Post by Zero-G. » Fri 14 Nov 2008 16:53

Hey

Have you been able to solve the problem in dotConnect 5?

THX

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 17 Nov 2008 09:42

The problem is not resolved.

Post Reply