Hi,

I already thought of this (thanks anyway). I was able to get a copy of my
client's database to try it myself and found nothing wrong with it and the
software worked fine on my computer with his database. We both have Windows
2000 Professional installed on computers that have comparable
configuration. The only difference is that he has IB 6.0 beta and I have FB
1.0 RC2. And, like I said my colleague uses IB6.0 beta and doesn't have the
problem. I've been using this query in the software for over 1 year now(the
client though has been with us for about 4 months now). It's only this
client in particular that seems to be getting this error. I'm up to the
point to think that it might be the installation of IB on his system. I
just want to make sure that I'm not missing something before going in the
direction of reinstalling IB on the client's system.

Daniel Rail

At 08/01/2002 05:38 PM, you wrote:

>It could be a query problem, not a database one. Maybe you are referring
>the field in a query where is not in the select, or using other properties
>(i.e. KeyLinks, Joinlinks, OrderingItems or so on) ad having it spelled
>wrong (double check the error message), or a mix of the above condition.
>Just a suggestion...
>Marco Menardi
>
>--- In IBObjects@y..., Daniel Rail <drail@n...> wrote:
> > Hi,
> >
> > I got a problem that is not making sense to me at all. I have a client of
> > mine that is getting the following error:
> >
> > Exception 'EIB_StatementError' in module filopto.exe at 00245909
> > FieldName: LASTNAME not found
> >
> > The ambiguity of this error is that the field does exists in the table
> > being referenced and the table is opened via another query prior to this
> > error. This error happens once my client has logged into my
> > application. If the field name really didn't exist several errors would
> > occur while the application is opening.
> >
> > The other ambiguity to this error is that I can't reproduce it and my
> > colleague either can't reproduce it. I'm currently using FB 1.0 RC2
> and my
> > colleague is using IB 6.0 beta. My client is using IB 6.0 beta.
> >
> > Anybody have ideas?
> >
> > I do have the call stack from the error generated by my client's
> system, if
> > it's helpful.
> >
> > Thanks in advance.
> >
> >
> > Daniel Rail
> > Senior System Engineer
> > ACCRA Group Inc. (www.accra.ca)
> > ACCRA Med Software Inc. (www.filopto.com)
>
>
>___________________________________________________________________________
>IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
>___________________________________________________________________________
><http://www.ibobjects.com>http://www.ibobjects.com - your IBO community
>resource for Tech Info papers,
>keyword-searchable FAQ, community code contributions and more !
>
>Your use of Yahoo! Groups is subject to the
><http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.