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

Will you please tell me how to do that..then I can post it? Thank you

--- In firebird-support@yahoogroups.com, "davidalbiston" <mail@...>
wrote:

>
> 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
> > > > > >
> > >
> >
>