Henry, You need to set the Cursorsetprop() properties. Specifically the following properties:
Buffering Tables UpdatableFieldlist UpdateNamelist KeyfieldList Wheretype Haven't got time to explain what they should be set to but post a question if you can't make it out as the documentation isn't obvious in the UpdatableFieldlist, UpdateNamelist and KeyfieldList properties. If you take a look at Paul McNett's make cursor updateable .prg program this will give you a good grounding. I think it is in the download files section of Ed's site. Dave C -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: 22 April 2010 15:05 To: [email protected]; [email protected] Subject: Updatable local view with multiple tables I just realized that I never before used updatable views where more than one table needed to be updated. I now see that the joinable fields do not get automatically filled (to maintain the JOIN). In the example below, I need to update all fields except 3: The two PKs (they are AutoInc) and HsgUnit.fk_address (I won't know the value until Address.pk_address gets auto-filled when a record is added to Address). SELECT Address.pk_address, (some ADDRESS fields), ; Hsgunit.pk_hsgunit, Hsgunit.fk_address, (some HSGUNIT fields) ; FROM LOCVIEW!ADDRESS ; INNER JOIN LOCVIEW!HSGUNIT ON Address.pk_address = Hsgunit.fk_address Considering that the view is JOINed by the pk_adress-fk_address, I would have expected HsgUnit.fk_address to get populated on save. What am I missing? Thx Henry [excessive quoting removed by server] _______________________________________________ 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.
