And I would strongly recommend making this a method of a Business Object dealing with the child cursor in general. E.g., DeleteChild(pkey) and UpdateChild(pkey).
Dan Covill San Diego On 9/2/2010 6:43 AM, Richard Kaye wrote: > 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> > _______________________________________________ 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/[email protected] ** 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.
