Do you have a table SKAAP with a column FAMILIE_ID?

The SQL statement you provided returns these values and GetValueList
concatenates them and fires SQL to get the data. The SQL created by
GetValueList is of more interest.

--- In firebird-support@yahoogroups.com, "ulrickebester"
<umeinhof@...> wrote:

>
> > >
> > >and I use
> > >
> > > GetValueList(QGetCard.FieldByName
> > >('TABLENAME').AsString,QGetCard.FieldByName
> > >('DISPLAYFIELD').AsString,QGetCard.FieldByName
> > >('LOOKUPTABLE').AsString,QGetCard.FieldByName
> > >('LOOKUPFIELD').AsString,QGetCard.FieldByName
> > >('IDFIELD').AsString,QGetCard.FieldByName
> > >('IDVALUE').AsString,QGetCard.FieldByName
> > >('DISPLAYNAME_E').AsString,grid,col,Filter,bCreateFilter);
> > >
> > >to get the data
> > >