Subject | RE: [IBO] Simple question about "Dataset cannot scroll" |
---|---|
Author | Helen Borrie |
Post date | 2004-11-29T10:41:10Z |
At 09:35 PM 29/11/2004 +1100, you wrote:
H.
> > Custom XxxxxSQL properties won't be needed. Thethen I suspect you forgot to set RequestLive true.
> > 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.
> >
>
>Helen, thank you once more for the help. I will have to get you something.
>
>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:Sorry, I don't understand how that's different to what you already have.
>
>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.
H.