>I want to use a SELECT statement to get a group
>of records instead of using SET FILTER. I want to make changes
>to these records and save the changes. Can you do that with a
>SELECT statement and how would I code something like that.
>
>Example:
>SELECT * FROM mytable WHERE myfld = 3
>Make changes to mytable and then put the mytable back to include all the records...
>SELECT * FROM mytable
>
>thanks
SELECT won't work here as the resultant set of data is read only in a separate cursor. Your best bet here would be to use a view. In conjunction with buffering, you will be able to do what you want.