How to run more than 24 values in the visual foxpro in the "In" clause? -


I am using FoxPro 5.0

I have more than 3,000 records to run a query, for example my query 

  remove from mytable.dbf where the field name is not in (1,2,3 , ...... 3909)   
 This does not execute. Because FoxPro only allows 24 records in these clauses. How can I execute this query? 
 No Simplification Ideas   
 
 
 The following code indicates how you can delete records in a table based on the records in another table Are there.  
 Conserve Table 1 (PKI) Create Table 1 (PK) values ​​in (1) INSERT (2) table 1 (PK) values ​​in Insert in Table 1 (PK) values ​​(3) Table 1 (PK) values ​​(4) Include in Table 1 (PK) values ​​(5) Insert table 2 (PKI) table 2 (PK) values ​​in cursor (2) Table 2 (PK) values Insert (4) Delete from table 1 where table 1.pk (Table 2 to select table 2.pk)

Comments

Post a Comment