Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Matching two cursors
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01337257
Message ID:
01337261
Views:
13
>>I have cursor ptTemp and cursor tprinters
>>Cursor ptTemp comes from aprinters ()
>>The cursor tprinters is from a table
>>
>>In need to keep only records with have the same .name in both cursors
>>
>>The ADD method works, but the DELETE method does not work
>>
>>*******************DELETE METHOD********************************************************
>> **** if a record from tPrinters does not exist in ptTemp, deletes it from ptTemp

If a record from tPrinters doesn't exist in ptTemp, when how can we delete it from ptTemp? How can we delete something that doesn't exist?

Very interesting! :)

BTW, you can re-write your ADD code to INSERT-SQL as well, would be just one command.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform