we recently updated from SDAC 8.0.4 to 9.1.2 and now found a situation where the provided value from a field in a TCustomMSDataSet to a parameter of an insert statement changed.
The TCustomMSDataSet in question is a TMSStoredProc with a select statement that is similar to this abstracted example:
Code: Select all
SELECT
t3.Value AS [V]
,t.Value AS [V_Compare_]
FROM dbo.Table t
OUTER APPLY
(
SELECT
t.V AS V
UNION ALL
SELECT
t2.V
FROM dbo.Table_2 t2
) t3
Is this working as intended? Is there any way around this additional matching behavior to basically get back the behavior prior to the upgrade?