This is a plain old VFP cursor, not an updatable view, right? Assuming you have primary keys, you can use standard SQL commands:
DELETE FROM <childtable> WHERE pkey=childcursor.pkey UPDATE <childtable> SET column=value[, column=value...] WHERE pkey=childcursor.pkey In a VFP DB, you can use DELETE & REPLACE statements. You may have a bit more work to do using xBase as depending on your scope you may need to position the record pointer first. Having said that, things get a bit more complicated if you're in a multi-user environment but you didn't ask about handling update conflicts... <g> rk -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kent Belan Sent: Thursday, September 02, 2010 9:26 AM To: [email protected] Subject: Updating child records Hello, Just wondering how others handle this situation, maybe there is a better way. I have a parent / child setup, where I pull a cursor of the child records and then allow add/edit/delete on the child cursor. How do you update the DBF with the child records ? This is easy when there are no child records found, just add all records from cursor. The hard part is when an existing child record is deleted from the cursor. How do you make sure the same record gets deleted from the live DBF and also update or add the changed or new records from the cursor ? Thanks, Kent _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/df1eef11e586a64fb54a97f22a8bd0441900496...@ackbwddqh1.artfact.local ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
