Please send me a simple sample application demonstrating the problem.

Jason Wharton

----- Original Message -----
From: "Delmar" <delmar@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, November 24, 2003 10:00 PM
Subject: [IBO] locate and filters exceptions


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