[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Foxpro 6.0 Delete N (top records) from a dbf table

Posted on 2010-03-24
2
Medium Priority
?
1,873 Views
Last Modified: 2012-05-09
Tryin to quickly delete first 1000 rows from a .dbf table.  What is the command?
0
Comment
Question by:athea123
2 Comments
 
LVL 43

Accepted Solution

by:
pcelba earned 2000 total points
ID: 28476375
USE YourTable
DELETE NEXT 1000  && This will mark first 1000 records for deletion

PACK  && This will physically remove above records from DBF file (exclusive opening is necessary)

0
 

Author Closing Comment

by:athea123
ID: 31706772
Thanks pcelba!  You're fast!
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Virtualization software lets you run different versions of Windows, Ubuntu Linux and other versions of Linux all at the same time, rather than running each one directly from your computer's hard drive.
Is your organization moving toward a cloud and mobile-first environment? In this transition, your IT department will encounter many challenges, such as navigating how to: Deploy new applications and services to a growing team Accommodate employee…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses

590 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question