Hello!
Could it be that Aurelius can't handle foreign keys of a negative value?
I've got an foreign key table who's ids currently reaching from -3 to 15.
If I now want to access the foreign key property of my refferecing table I get an error message.
"Im Projekt Timesheet.exe ist eine Exception der Klasse EMSSQLNativeException mit der Meldung
'[FireDAC][Phys][ODBC][Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '-'.' aufgetreten.
All other foreign key tables without a negative value are working correctly.
Maybe there's an workaround!?
regards
-Ren? H?ger
There should be no problem with negative values in foreign keys, but to be pretty sure, we have added some specific tests using negative values in foreign keys, and it works here (using lazy-loading and eager loading). Note that i'm talking about negative values, the value 0 (zero) is considered null and should not be used.
It doesn’t mean that there isn’t a problem in Aurelius, but it looks there is more in your case than just having negative values. Can you isolate more the problem, and maybe, if possible, create a test project that reproduces the issue?