I currently test the dotConnect for Oracle product.
I have a problem with using Joins SQL Statements if a column of a table is declared as a unique one.
I do something like this:
Code: Select all
SELECT
SYSER_ID,
SYSER_ART,
MODUL.MOD_NAME
FROM SYSTEMEVENTS
LEFT JOIN MODUL ON SYSTEMEREIGNIS.MOD_ID=MODUL.MOD_ID
If I execute the statement above, I get the exception "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."
This exception is occured while the MOD_NAME is multiple available in this statement. If I remove the MOD_NAME from the query, it works.
I also tested it with your Oracle-Sample program. The error occurs if I use the sample with "DataSet". If I use the sample "DbDataTable" I didn't get the exception and the query result is correct.
I also use the "Direct-Mode".
Can you help me on this issue?
With kind regards
ThorstenSt