Subject Re: [IBO] Fieldname not found error (again)
Author Daniel Rail
Just an update to my situation. I upgraded to IBO 4.2Fn. And, I did some
further testing. I found a parameter in the TIB_Query component that was
giving me an error, the parameter was OLNK_LASTNAME. I don't know how it
got there, but apparently this was causing the problem, because once it was
removed, the error disappeared.

Sorry to have not figured this out before, but I didn't add that parameter
and it's not part of the query. Does anybody know how come this parameter
was there?

Thanks anyway for anybody that would've scratched their heads on this problem.

Daniel Rail

At 14/01/2002 01:12 PM, you wrote:
>Forgot to mention. I'm using Delphi 5 Enterprise with latest upgrade and
>IBO 4.2Fm.
>
>Daniel Rail
>
>At 14/01/2002 12:53 PM, you wrote:
> >Hi,
> >
> >I posted this error a few days ago and did get some replies and tried
> >everything and I'm still getting this error. I was using the incremental
> >search component from IBO with TIB_Query, now I'm using my own edit box and
> >a button to do the search. I'm using a separate TIB_Cursor to locate the
> >record by using certain criteria via a parameterized query. But, the error
> >occurs when I do a TIB_Query.Locate. The call stack is quite lengthy after
> >that method is called.
> >
> >The error is:
> >Exception 'EIB_StatementError' in module Filopto.exe at 00245909
> >FieldName: LASTNAME not found.
> >
> >The only problem that I have with this is that the field is visible in
> >TIB_Grid and the TIB_Query.Locate is on the TIB_Query that is the
> >datasource of the TIB_Grid. The LASTNAME field is the sort order for the
> >grid. And, in the Locate method I'm using CLIENTNO.
> >
> >Do keep in mind that I was getting this error when using TIB_IncSearch on
> >LASTNAME instead of all the programming that I've recently done to see if
> >it wasn't that component that was at fault.
> >
> >This is pretty important to me to get this error fixed, because it's
> >occurring in an application that is on the market and actual clients are
> >using it(not all are reporting the error). I didn't get the error until I
> >made the last changes and I'm getting this error constantly.
> >
> >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>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/>http://docs.yahoo.com/info/terms/>Yah
> oo! Terms of Service.
>
>
>Yahoo! Groups Sponsor
>ADVERTISEMENT
><http://rd.yahoo.com/M=219350.1833377.3346791.1269402/D=egroupweb/S=1705007183:HM/A=935579/R=0/*http://www.gotomypc.com/u/tr/yh/grp/300_g2_01/g22lp?Target=mm/g22lp.tmpl>3281614.jpg
>3281650.jpg
>
>___________________________________________________________________________
>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.


[Non-text portions of this message have been removed]