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!