>Hello Foxperts,
>
>Is the following code 'proper'?
>REPLACE reprints WITH reprints+1 FOR flagged="P"
>REPLACE flagged WITH "O" FOR flagged="P"
>or should I do this:
>SCAN FOR flagged="P"
> REPLACE reprints WITH reprints+1, flagged WITH "O"
>ENDSCAN
>
>Any comment and critique gratefully accepted.
I think both are proper.
You can also:
update MyTable;
set reprints = reprints + 1, flagged = "O";
where flagged = "P"
This will automatically open, but not close, the table.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)