RE: Doing a SET with variables

Now we're talking about a "cursor"

exec sql declare c1 cursor for 
select this, that, etc, from myfile
where this=:myselection;

exec sql open c1

exec sql fetch c1 into :this, :that, :etc;
// your error trapping here
// your program logic here
exec sql update myfile
set ...
 where current of c1;

If you do a single row fetch, like
exec sql select this, that, etc into :this, :that, :etc
from myfile
where mykey=:mykey;

Do not then "assume" sql will only update the row you last fetched if you 
do a 
exec sql update myfile
set this=:this, ...;



Rob Berendt