asked on

delete records from a DBF table.

I have one DBF table names Sales and got one field called Serialno .

I need to delete away all the records from the above mentioned table & manged open the table using visual foxpro but do how can i exceute the commands.

Since i am very new to foxpro IDE, please explain the steps in detail..

Regards,
Niger

SOLUTION

hiteshgupta1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

hiteshgupta1

also read this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgtskDeletingRecords.asp

SOLUTION

DeepDan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

DeepDan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

fcarandangjr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

nyee84

ASKER

Experts,

Let me try ur code, will revert to you soon..

Best,
Niger

nyee84

ASKER

Hi Experts,

I have opened the dbf table and typed the below code in command prompt

USE ? EXCLUSIVE

Selected the table and when i hv used ZAP comand , I encountered an error message "Cannot update the cursor"

How do i resolve the above issue??

Best,
Niger

DeepDan

if you have included tha table that you want to ZAP in the project of the your exe, you can not ZAP it
-you include a dbf in the project, cause you dont want anything to change it... eventually you can not ZAP it, DELETE or UPDATE programmatically...

OR maybe you have SET SAFETY ON

please check this 2 and get back

SOLUTION

karunamoorthy

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial