BorlandTalk.com

Vuksa Vladislav · Guest

Example:

Select C.CityID, C.Name, S.StateID, S.Name As NameOfState

From City As C

Left Join State As S On (S.StateID=C.StateID)

If I change S.StateID I want to refresh S.Name. I do not want to use requery
'cos it is too slow.

I have tried:

ADO components using properties Recordset.Properties['Resync Command'] and
Recordset.Resync(adAffectCurrent, adResyncAllValues)

TBetterAdo - works with some simple examples, but if I use Join with View
containing SUM it does not work

DbExpress components have implemented RefreshRecord which doesn't work with
Join

I have not succeeded to find any reasonable solution.