A SQL Query like
Code: Select all
select TableA.KeyA, -- PrimaryKey, Identity TableA.Value as ValueA, TableA.Version, -- timestamp field TableB.Value as ValueB from TableA inner join TableB on TableB.KeyAB = TableA.KeyAB
On calling TMSQuery.RefreshQuick(TRUE) the exception with message 'Ambiguous column name Version' raises.
It occurs because TableB also have a field with name 'Version' (and Table B.Version has such purpose either as TableA.Version, though it not so important here). The SQLProfiler show it clarity.
But in query above is meant use the TableA .Version for RefreshQuick() because it explicitly specified, isn't it? I see to solve this problem by including the TableName into RowVersion field name while RefreshQuick executing.
Are you know about this problem and plan (or not) to solve it? And what (if not plan) can I make in such cases?
Oh yeah, in the latest build 22.214.171.124 the problem still exists.