You might consider using UIBSQLMonitor. It allows you to see exactly
which queries are sent to the database by your application (presuming
that your application is using fbclient.dll or gds32.dll).

Strangly they don't have an info page no more, so I only have the direct
link for you:

http://www.progdigy.com/files/UIBSQLMonitor.zip



Kind regards,
Michel



________________________________

Van: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Namens ulrickebester
Verzonden: donderdag 6 november 2008 13:22
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] Re: Interbase to Firebird conversion,
Delphi



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
<mailto:firebird-support%40yahoogroups.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

<mailto:firebird-support%40yahoogroups.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

<mailto:firebird-support%40yahoogroups.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

<mailto:firebird-support%40yahoogroups.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
> > > > > >
> > >
> >
>