Heeft er hier iemand eigenlijk ervaringen met FireDAC?
Ik heb de volgende vraag op het embarcadero forum geplant.
Misschien weet iemand hier wat er gebeurt?
Is dit de "schuld" van FireDac of SQL Server?
-------
Using a firedac TFDQuery with a join on SQL Server gives unpredictable results regarding the OrigTabName and OrigColName.
(using extendedmetadata)
It seems the order of the fields in the selectlist has influence???
Any help here would be greatly appreciated!
The first example does NOT give the original tablename and original field.
The second example DOES give them.
Code:// first select B.ID, A.ID from A inner join B on B.ID = A.B_ID where A.ID = :SomeParam // second select A.ID, B.ID from A inner join B on B.ID = A.B_ID where A.ID = :SomeParam
Bookmarks