Page 1 of 1

Problem whee tablen using MySQLDataTable

Posted: Fri 28 Sep 2007 11:56
by iad
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

Posted: Fri 28 Sep 2007 12:20
by Alexey
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.

Posted: Sat 29 Sep 2007 20:37
by iad
Alexey,
i sent you email with DB and solution,
waiting for your reply

Lior,

Posted: Mon 01 Oct 2007 06:33
by Alexey
We will investigate the problem. Look forward to hearing from me again.