Subject Re: [IBO] Problem with Search Mode
Author Helen Borrie
At 12:57 PM 15/11/2003 +0100, you wrote:
>Hello Helen,
>
> > What about the properties of the detail query? That incomplete search
> > query string in the Monitor is the clue...
>
>here they are:
>
> object qAnspr: TIB_Query
> DatabaseName = 'localhost:makler3'
> FieldsDisplayLabel.Strings = (
> 'VORNAME=Vorname'
> 'NACHNAME=Nachname'
> 'TITEL=Titel'
> 'GEBURTSDATUM=Geb.dat.'
> 'GESCHLECHT=Geschlecht'
> 'ANREDE=Anrede')
> FieldsDisplayWidth.Strings = (
> 'VORNAME=133'
> 'NACHNAME=148'
> 'TITEL=86'
> 'GEBURTSDATUM=78'
> 'GESCHLECHT=150')
> FieldsVisible.Strings = (
> 'ID=FALSE'
> 'PID=FALSE')
> IB_Connection = dmMain.cnMain
> SQL.Strings = (
> 'SELECT ANREDE'
> ' , VORNAME'
> ' , NACHNAME'
> ' , TITEL'
> ' , GEBURTSDATUM'
> ' , ID'
> ' , PID'
> ' , GESCHLECHT'
> ''
> 'FROM T_ANSPRECHPARTNER')
> ColorScheme = False
> DefaultValues.Strings = (
> 'GESCHLECHT=M'
> 'ANREDE=Herr')
> GeneratorLinks.Strings = (
> 'ID=GEN_Ansprechpartner.ID')
> KeyLinks.Strings = (
> 'T_ANSPRECHPARTNER.ID')
> MasterSource = dsMakler
> MasterLinks.Strings = (
> 'T_Ansprechpartner.PID=T_Personal.PID')

Is the MasterLink correct? As KeyLink for the master set you have
'T_PERSONAL.ID')

Somehow, from your earlier monitor output, it seems IBO cannot make sense
of the link between T_Ansprechpartner.PID and T_Personal.PID. Could it be
a mistake?

Helen