>------
>Hi Pablo.. I tried it... what I am trying to do is SET A FILTER, make
>changes, and save those changes.. I am trying to us a SELECT statement to
>make my FILTER. If I use SELECT * FROM mytable INTO CURSOR mycursor...
>my FILTER is the data in mycursor... I need the FILTER to be in mytable...
>when I am finished... I will SELECT * FROM mytable to recover all of the table.
>any ideas?
Yes, then you musn´t use the select, you need an updatable view, issue a CREATE VIEW (usually a local view), make your changes, and then do a TABLEUPDATE, and all your changes will be in your table, if you dislike your changes do a TABLEREVERT. If you dont get up with this I'll send you a sample.
Review the solutions in:
SET DEFA TO (_SAMPLES)
DO ? (search the solution.app)
and see the trastade sample,
Regards,