The problem must be in the generated SQL. If you post that then we can
have a look.

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

>
> Yes I do,

> I get the error on skaap.FAMILIE_ID and on skaap.GEBOORTE_STATUS_ID
>
> column not found
> I checked the sql generated by getvaluelist, it is correct,
> it just doesn't find the column :(
>
> --- In firebird-support@yahoogroups.com, "davidalbiston" <mail@>
> wrote:
> >
> > 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
> > > > >
> >
>