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!

1 comment:

Software Development in Sydney Blog said...

Your post is very interested. It is very useful and helpful fro me. Thanks for share this valuable post.