DELETE MyTable; FROM MyTable; JOIN MyCursor ON MyCursor.Id = MyTable.Id UPDATE MyTable; SET SomeField = SomeValue; FROM MyTable; JOIN MyCursor ON MyCursor.Id = MyTable.Id>First, I pull some records:
>SELECT *; > FROM MyTable; > WHERE SomeValue = 1; > INTO CURSOR MyCursor >>
> > UPDATE MyTable; > SET SomeField = SomeValue; > WHERE Id IN; > (SELECT Id FROM MyCursor) > > ** OR > > DELETE FROM MyTable; > WHERE Id IN; > (SELECT Id FROM MyCursor) > >>