Problem whee tablen using MySQLDataTable

Problem whee tablen using MySQLDataTable

Postby iad » Fri 28 Sep 2007 11:56

hi,
im using MySQLDataTable and execute stored procedure that return a table from a join.
one of the fields in this query is coming from a table that heis there a Unique.
Now in the Query result i get a list of fields and i have muiltple values
when i execute the SP
i got the exception :
Column 'MasterID' is constrained to be unique. Value '1710' is already present.

why this component don't let me load a result set that one of the fileds are not unique ?
BTW, in Delphi, all is working right
what i'm doing wrong ?

Lior
iad
 
Posts: 34
Joined: Fri 24 Nov 2006 07:38

Postby Alexey » Fri 28 Sep 2007 12:20

Please send me a small test project to reproduce the problem.
Include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby iad » Sat 29 Sep 2007 20:37

Alexey,
i sent you email with DB and solution,
waiting for your reply

Lior,
iad
 
Posts: 34
Joined: Fri 24 Nov 2006 07:38

Postby Alexey » Mon 01 Oct 2007 06:33

We will investigate the problem. Look forward to hearing from me again.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL