Subject locate and filters exceptions
Author Delmar
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]