Sunday, October 25, 2009
Delete Top Records with SQL - Foxpro shortcut
The easiest way to delete records (top records) in foxpro is to simply type, "delete from table_name where recno()<=4000" This doesn't work correctly if you order the table in a way other than set by its index. You could delete the index then try it, but if you just need the top X amount of records as it's ordered, and it hasn't changes, it works great!
Labels / Tags:
delete top,
foxpro,
SQL
Subscribe to:
Posts (Atom)