Subject Re: [IBO] Locate method generate a exception when dont find a information
Author Cipto KH
Hi Jason,

Is this bugs already solved? I also has this bug if I use TIBOQuery with Woll2Woll search dialog component

Thank you


On 4/19/2017 6:48 AM, 'IBO Support List' supportlist@... [IBObjects] wrote:
 

This looks like a bug of some kind.

Will you send me a little sample app to me that shows me this error happening?

The more simple you can have the app be, the better.

 

Thanks,

Jason Wharton

www.ibobjects.com

 

 


From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com ]
Sent: Wednesday, March 08, 2017 10:47 AM
To: IBObjects@yahoogroups.com
Subject: [IBO] Locate method generate a exception when dont find a information

 




Firebird 2.5.6

 

IBO 5.9.1.2522 Trustware (with my old IBO registred version i dont have this error)

 

Samples situation

 

querDados is a IB_QUERY

 

If not querDados.Locate('NAME', 'MISTER FRIEND', [lopCaseInsensitive, lopPartialKey]) then

   MessageBox(0, 'Not find!', 'Warnning', MB_ICONWARNING or MB_OK);

 

   If i have 'MISTER FRIEND' ok no problem, but if i dont have the exception is generate... 

 

Now a days a need change my project to....

 

try

   querDados.Locate('NAME', 'MISTER FRIEND', [lopCaseInsensitive, lopPartialKey]);

except

   MessageBox(0, 'Not find!', 'Warnning', MB_ICONWARNING or MB_OK);

end;

 

above

 

ERROR MESSAGE

 

ISC ERROR CODE:335544569

 

ISC ERROR MESSAGE:

Dynamic SQL Error

SQL error code = -104

Token unknown - line 3, column 23

?

 

 

STATEMENT:

(TApplication).formOrcamentos.querDados._locatecursor_querDados

 

 

STATEMENT:

(TApplication).formOrcamentos.querDados

 

SQL MESSAGE

 

SQL ERROR CODE:-104

 

SQL ERROR MESSAGE:

Invalid token

 

SQL

 

SELECT ORCAMENTOS_VENDAS.PK_ORCS_VENDAS

FROM ORCAMENTOS_VENDAS

where (data between ?/* P00and */ ?/* P01 */)

  AND (((UPPER( CLIENTE_NOME ) <= UPPER( ?/* LOC_3 */ ))))

ORDER BY CLIENTE_NOME DESC

 

 




Virus-free. www.avast.com