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=egroupweb/S=1705007183:HM/EXP=1069803303/A=1853618/R=0/*http://www.netflix.com/Default?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/>.