>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.

The table is already open in this case.
Thanks for the guidance. I have not dabbled with SQL stuff much, but I see it is quite powerful.