1) select project_id into xproj from fgt_assignments
where id = xassign_id for update;
>> It looks like a case for cursor processing ( if you're expecting
multiple rows ) : decalere / open / fetch/close
declare cursor1 cursor for
select project_id
from fgt_assignments
where id = xassign_id
for update of 'the column name to be updated'
open cursor1
fetch cursor1 into :xproj
update fgt_assignments
set 'column name to be updayed' = 'some value'
where current of cursor1
close cursor1
Refer to the Sql Programming guide for details .
2) select 1 from dual;
>> select 1 from sysibm.sysdummy1
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
