Yes I do,

CREATE TABLE SKAAP (
SKAAP_ID INTEGER NOT NULL,
DIENS_KODE_ID INTEGER,
LAM_GEMAK_ID INTEGER,
GESLAG_ID INTEGER,
FAMILIE_ID INTEGER,
STATUS_ID INTEGER,
SEASON_ID INTEGER,
APPENDIX_ID INTEGER,
LAM_OPMERKING_ID INTEGER,
GEBOORTE_KODE_ID INTEGER,
SKAAP_NOMMER_VOLG CHAR(4),
ANIMALREMARK VARCHAR(500),
GEBOORTE_STATUS_ID INTEGER,
SKAAPPIC BLOB SUB_TYPE 0 SEGMENT SIZE 80,
MOEDER_ID INTEGER,
VADER_ID INTEGER,
SKAAP_NOMMER_STOET CHAR(4),
F_GEN INTEGER,
STUDBOEK_NO INTEGER,
GEBOORTEDATUM TIMESTAMP,
SKAAP_NOMMER_JAAR CHAR(4),
PEDIGREE_NUM VARCHAR(20),
REG_NUM VARCHAR(10),
NAAM VARCHAR(20),
INTERGIS_COMPNO VARCHAR(14),
ELECTRONIC_NO VARCHAR(30),
STATUS_DATE TIMESTAMP,
USE_RAM VARCHAR(3),
GEBOORTEGEWIG NUMERIC(6,2),
TEMPINDEX1 NUMERIC(6,2),
TEMPINDEX2 NUMERIC(6,2),
TEMPINDEX3 NUMERIC(6,2),
TEMPINDEX4 NUMERIC(6,2),
SKAAPPIC2 BLOB SUB_TYPE 0 SEGMENT SIZE 80,
SKAAPPIC3 BLOB SUB_TYPE 0 SEGMENT SIZE 80,
LAST_LAMBING_DATE TIMESTAMP,
BLUP_TOTAL_WEANED_ACC INTEGER,
BLUP_TOTAL_WEANED NUMERIC(6,2),
IN_BREED_COEFF NUMERIC(6,2),
BLUP_EBV_BIRTH_DIRECT NUMERIC(6,2),
BLUP_EBV_BIRTH_MATERNAL NUMERIC(6,2),
SOLD_DATE TIMESTAMP,
SOLD_AMOUNT NUMERIC(6,2),
ADDRESS_ID INTEGER,
TEMPMARK_ID SMALLINT,
REGISTERED_ID SMALLINT DEFAULT 0,
REV NUMERIC(9,2),
REV_SIRE NUMERIC(9,2),
REV_DAM NUMERIC(9,2),
BLUP_EBV_BIRTH_DIRECT_ACC NUMERIC(6,2),
BLUP_EBV_BIRTH_MATERNAL_ACC NUMERIC(6,2),
LOTNR VARCHAR(10),
SYMBOL_BIRTHDIRECT VARCHAR(3),
SYMBOL_TWW VARCHAR(3),
SYMBOL_REV VARCHAR(3)
);

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