hi,
Can this be done in the Update-- Sql ?

CREATE CURSOR foo1 (f1 I , f2 I NULL,f3 I NULL)
INSERT INTO foo1 VALUES (1,10,0)
INSERT INTO foo1 VALUES (2,20,0)
INSERT INTO foo1 VALUES (5,50,0)
INSERT INTO foo1 VALUES (6,60,0)
INSERT INTO foo1 VALUES (7,70,0)
INSERT INTO foo1 VALUES (8,80,0)
INSERT INTO foo1 VALUES (9,90,0)


UPDATE foo1 SET f1=afoo1.f2 , f2=afoo1.f1 from foo1 afoo1 WHERE foo1.recno() = afoo1.recno()
UPDATE foo1 SET f1=afoo1.f2 , f2=afoo1.f1 from (select * from foo1 ) as afoo1 WHERE foo1.recno() = afoo1.recno()

Both returnerror " object afoo1 not found"


After creating another cursor with name afoo1 and the same values and then still the same error ?? with

UPDATE foo1 SET foo1.f1=afoo1.f2 ,foo1.f2=afoo1.f1 from afoo1 WHERE foo1.recno() = afoo1.recno() 

Is Recno() not recognised as a where clause or Should it be something else ?

Suhas.