Re: Repetitive updates on an SQL routine inside a SQR

[Chuck.L.King@SEALEDAIR.COM]

That was the problem Robert, thanks!  I don't know why I didn't call the update
procedure from within the main select procedure; I usually do.  Thanks again.

Chuck L. King

-----------------------------------------------------------------------------
>From Robert Hallmark
-----------------------------------------------------------------------------
Chuck,

Try calling the "update_printed_field" procedure from within the procedure
which pulled &idnumber.
For example:

begin-procedure get_idnumber
begin-select
idnumber        &idnumber
  do update_printed_field
  from tablename
  where something = something
end-select
end-procedure


Bob Hallmark