Problem whee tablen using MySQLDataTable

iad · Post by **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

Alexey · Post by **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.

iad · Post by **iad** » Sat 29 Sep 2007 20:37

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

Lior,

Alexey · Post by **Alexey** » Mon 01 Oct 2007 06:33

We will investigate the problem. Look forward to hearing from me again.