GetUpdatingTable and Extract

[Andrey Maximenko. Ukraine]

SELECT	ROWID, n.*, EXTRACT(YEAR FROM SYSDATE) YEAR FROM nsi3001 n
.
OracleDataSet1.GetUpdatingTable => SYSDATE
.
.
.
SELECT	ROWID, n.* FROM nsi3001 n
.
OracleDataSet1.GetUpdatingTable => NSI3001

DOAVersion = 4.1.0.0

 

[Marco Kalter]

We'll enhance this. For the moment you need to explicitly set TOracleDataSet.UpdatingTable to NSI3001.