nyee84
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Experts,
Let me try ur code, will revert to you soon..
Best,
Niger
Let me try ur code, will revert to you soon..
Best,
Niger
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
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
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
-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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dgtskDeletingRecords.asp