Subject | RE: [IBO] Simple question about "Dataset cannot scroll" |
---|---|
Author | Daniel Jimenez |
Post date | 2004-11-29T10:35:02Z |
> Custom XxxxxSQL properties won't be needed. TheHelen, thank you once more for the help. I will have to get you something.
> Master-detail relationship will take care of the first
> segment of the key, the Lookup relationship will take care of
> the second. All that's needed is to pop a TIB_LookupCombo
> into the detail grid.
>
It works :-))))))))))
I had to provide EditSQL and DeleteSQL, otherwise it was not allowing
updates or deletions.
If I was to change the detail query to:
SELECT ACM_DOUBLEKNOCKITEMS.DNI_DN_ID
, ACM_DOUBLEKNOCKITEMS.DNI_AC_ID
, ALARMCODES.AC_DESCRIPTION AS ACDESCRIPTION
FROM ACM_DOUBLEKNOCKITEMS
INNER JOIN ALARMCODES ON
ALARMCODES.AC_ID=ACM_DOUBLEKNOCKITEMS.DNI_AC_ID
Would it be correct from your point of view, as at a later stage, the set of
ALARMCODES.AC_ID will be restricted to match a particular value.
Thank you very very very much
danieL.
____________________________
Comvision Pty. Ltd.
www.comvision.net.au