Subject | Re: [IBO] Help with dataset only containing one record, the last inserted record, inside the AFTERACTION OF AN IB_UPDATEBAR?? |
---|---|
Author | Helen Borrie |
Post date | 2006-12-27T12:05:09Z |
At 10:39 PM 27/12/2006, you wrote:
string of the form (using your example)
ANIMAL.ANIMALID=ANIMALPHOTO.ANIMALPHOTOANIMALID
i.e. detail link on the left, and an equals sign with no spaces.
You can't assign MasterLinks in code using a Delphi assignment
operator. You must use
aDataset.MasterLinks.Add('ANIMAL.ANIMALID=ANIMALPHOTO.ANIMALPHOTOANIMALID');
I suspect IBO is somehow parsing something out of your code but, at
best, it will have the relationship reversed because it's being told
that ANIMALPHOTO is the detail side.
Helen
>I have the following setupThis is wrong. MasterLinks is an ib_stringlist. Each entry is a
>IB_QueryANIMAL
>Select ANIMALNAME, ANIMALID from ANIMAL (simplified)
>
>IB_QueryPHOTOS
>Select ANIMALPHOTOANIMALID, ANIMALPHOTO, ANIMALPHOTOID,
>ANIMALPHOTOORDER, From ANIMALPHOTO (simplified)
>
>Mastersource of IB_QueryPHOTOS := IB_QueryANIMALDatasource.
>Masterlinks: ANIMALPHOTO.ANIMALPHOTOANIMALID := ANIMAL.ANIMALID
string of the form (using your example)
ANIMAL.ANIMALID=ANIMALPHOTO.ANIMALPHOTOANIMALID
i.e. detail link on the left, and an equals sign with no spaces.
You can't assign MasterLinks in code using a Delphi assignment
operator. You must use
aDataset.MasterLinks.Add('ANIMAL.ANIMALID=ANIMALPHOTO.ANIMALPHOTOANIMALID');
I suspect IBO is somehow parsing something out of your code but, at
best, it will have the relationship reversed because it's being told
that ANIMALPHOTO is the detail side.
Helen