>I am using 2.6, although I have 7.0(it's a migrataion thing).
>My question:
>Using the sql select statement, is there any way to write to the results, and update the database?
>example
>I have 1000 different locations, with several customers for each location. I want to tag 1 record for each location.
>There are several ways to do this, but I was hoping to discover a way to write directly to the data that meets the criterea. Any help?
Instead of SQL - SELECT, use SQL - UPDATE to change records that meet criteria. You can also use the old-fashioned REPLACE ALL.
Hilmar.
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)