Master / Detail

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
User

Master / Detail

Post by User » Thu 29 Dec 2005 03:38

Dear Sir/Madam,


I have master and detail tables. When I scrolling master table, if detail table is emtpy and scroll back detail table is not empty. It will duplicate one set every time until press refresh button.



System:-
Delphi 7
MySQL 5.0.16
2.60.7

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 29 Dec 2005 10:19

We couldn't reproduce the problem.
Please send us (dbxmda*crlab*com) a complete small sample to demonstrate it and include script to create and fill tables.

User

Master / Detail

Post by User » Thu 29 Dec 2005 19:44

Small sample sent

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 30 Dec 2005 10:57

Please specify exact sequence to reproduce the problem.

User

Post by User » Fri 30 Dec 2005 15:17

1. First Load - OK
2. Move master to '...2', Detail OK
3. Move master to '...3', Detail OK
4. Move master to '...4', Detai empty record
5. Move master prior, Detail duplicate once each time

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 03 Jan 2006 12:46

We reproduced the problem. The source of the problerm is in dbExpress implementation. You can check it by using standard driver. ClientDataSet doesn't use connection to server to get detail values on master navigation.

User

Post by User » Tue 03 Jan 2006 15:28

How to solve this problem? Standard driver doesn't support higher mysql sever. So, I bought this product.

Another problem, When I adding, edting data very times, it will very slow unit I reload data.

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 04 Jan 2006 14:44

> How to solve this problem?
This is error in Borland's ClientDataSet code. We can't advise any method
to avoid it.

> When I adding, edting data very times, it will very slow unit I reload data.

Do you mean time of executing ApplyUpdates method?

User

Post by User » Fri 06 Jan 2006 10:09

How to solve this problem?
This is error in Borland's ClientDataSet code. We can't advise any method
to avoid it.

You mean is Delphi 7.1 bugs ? How about Delphi 2006 version?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 06 Jan 2006 12:20

> You mean is Delphi 7.1 bugs ? How about Delphi 2006 version?

We can't provide any information about fixes in different Delphi versions.

User

Post by User » Sun 08 Jan 2006 09:43

How about your product MyDAC?
If the problem caused by cds and no solutions, can I switch to MyDAC?
Is it can solve it?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Tue 10 Jan 2006 10:57

Yes, migration to MyDAC would solve the
problem, because source of it lies in dbExpress technology. You can check it by trying MyDAC trial. You can download it for free from our site.

User

Post by User » Tue 10 Jan 2006 18:54

I bought dbexpress within one month. Can I arrange change to MyDAC?

Devart
Devart Team
Posts: 3199
Joined: Tue 26 Oct 2004 13:51

Post by Devart » Wed 11 Jan 2006 15:21

Please email your developer license number to our sales team at sales*crlab.com

Post Reply