My problem is basically as follows:
I have a Delphi form with 2 DBEdit fields;
I will refer to them here by DBEditX and DBEditY.
The fields are bound to a dataset with this SQL statement:
SELECT T1.RowID, T1.X AS X, NVL(T2.Y, T1.Y) AS Y
FROM T1, T2
WHERE T1.FK = T2.PK (+)
(1)
If T1.FK is NULL...