>>------
>>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,
--------------
Hi Pablo ... Could you send me a small sample of code... :)