Re: Field 'ID' can not be modified in master/detail


"Eugene V. Goldberg" <egold@xxxxxxxxx> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅÅ: news:470f4d83@xxxxxxxxxxxxxxxxxxxxxxxxx
so any workaround for this?
Change yours pk names so that they will be unique acrooss DB.
If you cant do that. then:
1. Change Master SQL to: SELECT a.ID as MASTER_ID, a.* FROM MASTER a
2. Change Detail SQL to: SELECT * FROM DETAIL WHERE MASTER_ID = :MASTER_ID
3. Make sure that fake MASTER_ID is always the same as ID (my concern is
about insertion into Master dataset)

i think this is only the case with ADO master-detail implementation,
i dont think other libraries put a value to detail foreign key field...
You are wrong here (at least for Delphi world).

HTH,
Vitali


.

Relevant Pages

  • it is better but activation ughhhh
    ... i cant even get an activation window to pop up it says i ... have two days left...i am obviously not the master of my ... you dont have to pay more to activate but it sucks when ...
    (microsoft.public.windowsxp.general)
  • Re: ku format
    ... What are you referring to by "digital?" ... end up doing a master reset!).... ... cant seem to get any analog/digital on the ku sat ... TIA ...
    (rec.video.satellite.tvro)
  • Re: whats the errors here?
    ... I just started to explore TeXnicenter today myself. ... I think it's quite difficult and quite handy if I can master it. ... I still cant get all the error disappear by myself.. ...
    (comp.text.tex)
  • Re: The Powerball Has Spoken
    ... Sounds awesome Gregg. ... TZ is a perfect fit for a mod master like ... Cant wait to see it up close and personal in a couple weeks. ...
    (rec.games.pinball)
  • Re: Inserting comment depending on the Conditional formatting
    ... but i cant get it. ... Little Master ... Little Master's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28227 ... Prev by Date: ...
    (microsoft.public.excel)