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

1. are you adding a new detail for an existing master or are you creating
new master/detail records ?

yes, new detail for existing master record.

2. does the detail dataset refer to the master dataset to get the key ?

if you mean foreign key field value, the answer is no. the exception happens
even before OnNewRecord event where i want to set the foreign key value.

i am just clicking + on dbnavigator and exception happens.

Thanks,
Eugene.


.

Relevant Pages

  • Re: Q: deleting relations
    ... The exception is telling you to remove your indexes first - there is a foreign key index from the child table to the parent. ... To do this I obviously need to temporarily switch off the relations. ... Cannot remove unique constraint 'Constraint1'. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: The Trouble With Transactions
    ... If you get exception in BeginTrans you should not call RollbackTrans. ... > Why don't you store the primary key of InvoiceHeader in InvoiceDetail? ... >> From what I can gather, ADO treats each statement within the command ... > Did you declare the foreign key in InvoiceDetail? ...
    (borland.public.delphi.database.ado)