Search code examples
foxpro

Select into an exisiting table using FoxPro

Hi I am currently using FoxPro and may I know if there is any possible chance to select into exisiting table by overwritting it.

For example: I wanted to achieve this: SELECT * FROM table1 WHERE criteria INTO TABLE table1.

Thanks in advance.

Solution

  • No. How about

    use table1 excl
delete from table1 where !criteria
pack in table1