| Subject | RE: [IBO] Locate method generate a exception when dont find a information |
|---|---|
| Author | Jason Wharton |
| Post date | 2017-09-06T17:07:24Z |
Yes, this bug should be solved already.
Did you get the latest update of IBO?
It is build 5.9.5 Build 2652.
Please let me know if you find any additional problems.
Kind regards,
Jason Wharton
www.ibobjects.com
From:
IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Sunday, August 27, 2017 1:15
AM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Locate method
generate a exception when dont find a information
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
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
