Unzip attached file, restore database backup and run
EXECUTE BLOCK
AS
DECLARE F1 INT;
DECLARE F2 INT;
BEGIN
FOR SELECT T1.ID, T2.ID
FROM TABLE1 T1, TABLE2 T2
WHERE T1.ID = T2.ID
INTO :F1, :F2
AS CURSOR CUR
DO
UPDATE TABLE1 SET NAME = :F1 + :F2 WHERE CURRENT OF CUR;
END
Vlad Khorsun added a comment - 20/Nov/06 12:23 AM Unzip attached file, restore database backup and run
EXECUTE BLOCK
AS
DECLARE F1 INT;
DECLARE F2 INT;
BEGIN
FOR SELECT T1.ID, T2.ID
FROM TABLE1 T1, TABLE2 T2
WHERE T1.ID = T2.ID
INTO :F1, :F2
AS CURSOR CUR
DO
UPDATE TABLE1 SET NAME = :F1 + :F2 WHERE CURRENT OF CUR;
END
Bug
Closed
Major
AV at rollback and \ or garbage collection if updated table have expression index with SELECT in it
EXECUTE BLOCK
AS
DECLARE F1 INT;
DECLARE F2 INT;
BEGIN
FOR SELECT T1.ID, T2.ID
FROM TABLE1 T1, TABLE2 T2
WHERE T1.ID = T2.ID
INTO :F1, :F2
AS CURSOR CUR
DO
UPDATE TABLE1 SET NAME = :F1 + :F2 WHERE CURRENT OF CUR;
END