Re: ORDER BY vs. UPDATE

In article <1992Mar21.011459.01065433@locus.com>, jfr@locus.com (Jon Rosen) writes: |> In article <1992Mar20.225616.13544@pmafire.inel.gov> geoff@pmafire.inel.gov (Geoff Allen) writes: [...most of article deleted...] |> You can also read out the whole table to a regular file, do the |> reranking, erase the existing table and reinsert all the rows. |> |> No, its not pretty, but then neither is SQL :-) |> |> Jon Rosen You could also take this approach within 4gl - read out the whole table to a duplicate table, doing the reranking in the process, and replace the original with the duplicate. ---------------------------------------------------------------------------- | Mitch Amiano Current Work Phone: 716-477-3506 | | Address: amiano@music.kodak.com | ----------------------------------------------------------------------------