| Subject | Re: [IBO] Locate method generate a exception when dont find a information |
|---|---|
| Author | Cipto KH |
| Post date | 2017-08-27T07:15:09Z |
Is this bugs already solved? I also has this bug if I use TIBOQuery with Woll2Woll search dialog component
Thank you
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
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
