Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.
Question
Delete all records in a table that match records in 2nd table
I am using VFP 6. I have 2 .dbf's, contract.dbf & deposit.dbf. Both tables have a field called tranid & have indexes setup on that field.
I need to delete all records in deposit.dbf that have the same tranid as those in contract.dbf. I have tried the following but no records are deleted.
sele 1
USE deposit.dbf orde depoti
sele 2
USE contract.dbf orde contractti
sele deposit
set rela to tranid into contract
delete all for deposit.contnumb=loan.cont
Solution
About this Solution
Sign up Now to View This Solution- Zone
- general
- Tags
- delete
- Participating Experts
- 1
- Solution Grade
- A
Posted on 2012-02-18 at 14:41:43ID: 37614841
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.