Don't work. I'm using components derived from Tdataset.
I define in TIBOdatabase SQLDialect=3, but the problem persist.

> Hi,
>
> Iam not sure it with but can you take a look at the dialect setting in
> your ib_connection? I think it should be in 3 to work well.
>
> Tell me if it works.
>
> Cheers
>
> James
>
>
> Delmar wrote:
>
> > Hi,
> >
> > I'm from Brazil and my English don't is perfect
> >
> > I need some help
> >
> >
> >
> > I´m using firebird 1.5 RC4 for windows, IBO 4.2Ie to migrate on
> > application from BDE. Its my firts time. All rigth is OK, except, that
> > I get two errors
> >
> >
> >
> > First error occur when I use a IBOquery.locate. My SQL string is:
> >
> > "select titular.codico, titular.titular as nome from titular order by
> > titular.titular" and is OK;
> >
> >
> >
> > My locate command is:
> >
> > dmq.Qbusca.Locate('titular',edit1.Text,[loCaseInsensitive,

loPartialKey]);

> >
> >
> >
> > The locate method create this exception when dont found the character
> >
> > By example:
> >
> >
> >
> > DELMAR
> >
> > DELMAR W
> >
> > DELMAR BLATT
> >
> >
> >
> > If the entry is "DELMAR" then OK
> >
> > but "DELMAR WW" that dont exists raise the exception
> >
> >
> >
> > ISC ERROR MESSAGE:
> >
> > Dynamic SQL Error
> >
> > SQL error code= -104
> >
> > Token unknown - line 4, char 34
> >
> > order
> >
> >
> >
> > STATEMENT
> >
> > TIB_LocateCursor:
> >
> > "<TApplication>, dmq.Qbusca.IBOqrQbusca.<TIB_LocateCursor>."
> >
> >
> >
> > STATEMENT:
> >
> > TIBOInternalData': Process stopped. Use Step or Run to continue
> >
> >
> >
> > Second error occur when I use filters
> >
> > My filters are:
> >
> > dmq.Qbusca.Filter:='nome='+quotedstr(edit1.text+'*');
> >
> > dmq.Qbusca.Filtered:=true;
> >
> >
> >
> > ISC ERROR MESSAGE:
> >
> > Dynamic SQL Error
> >
> > SQL error code=-104
> >
> > Token unknown -line5, char 34
> >
> > Order
> >
> >
> >
> > STATEMENT:
> >
> > TIBOInternalDataset: "<TApplication>.dmq.Qbusca.IBOqrQbusca."
> >
> > Process stopped. Use Step or Run to continue
> >
> >
> >
> > There are some addictional configuration that I don't have make...
> >
> > What is wrong?
> >
> >
> >
> > Its my first time with ibo and my first migration.
> >
> >
> >
> > I am thankful for help
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > *Yahoo! Groups Sponsor*
> > ADVERTISEMENT
> >

<http://rd.yahoo.com/SIG=12cvtbfcu/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1069803303/A=1853618/R=0/*http://www.netflix.com/Def
ault?mqso=60178338&partid=4116730>

> >
> >
> >
> >

___________________________________________________________________________

> > IB Objects - direct, complete, custom connectivity to Firebird or
> > InterBase
> > without the need for BDE, ODBC or any other layer.
> >

___________________________________________________________________________

> > 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 Yahoo! Terms of Service
> > <http://docs.yahoo.com/info/terms/>.
>
>
>
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> 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 http://docs.yahoo.com/info/terms/
>
>