>>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.
--------------
Hi Nigel and thanks for your reply...
Could you give me a small sample in code of what you mean?
thanks