Subject | Problems with Locate method |
---|---|
Author | hcarvajalsy <hcarvajalsy@yahoo.com> |
Post date | 2003-02-25T19:22:24Z |
Hello,
I am using a TIBOQuery with Interbase 6.0 in order to be able to
move around the selected data. When I try to use the locate method,
I am always getting a true result, regardless of having the searched
data or not. The calls are similar to the following:
if Mainform.oItem.db.IBItem_.Locate('DISTNO;SCHOOL;ITEM',
VarArrayOf([IntToStr(CurrData.DistNo), CurrData.School,
SearchKey]),
[loCaseInsensitive]) then
begin
...
I have tested the following:
if Mainform.oItem.db.IBItem_.Locate('DISTNO',888,
[loCaseInsensitive])
then ShowMessage('DistNo 888');
without having a DISTNO equal to 888 in my SQL table, and the Locate
will be true. I will be grateful for any help on this problem.
Regards,
Horacio Carvajal
I am using a TIBOQuery with Interbase 6.0 in order to be able to
move around the selected data. When I try to use the locate method,
I am always getting a true result, regardless of having the searched
data or not. The calls are similar to the following:
if Mainform.oItem.db.IBItem_.Locate('DISTNO;SCHOOL;ITEM',
VarArrayOf([IntToStr(CurrData.DistNo), CurrData.School,
SearchKey]),
[loCaseInsensitive]) then
begin
...
I have tested the following:
if Mainform.oItem.db.IBItem_.Locate('DISTNO',888,
[loCaseInsensitive])
then ShowMessage('DistNo 888');
without having a DISTNO equal to 888 in my SQL table, and the Locate
will be true. I will be grateful for any help on this problem.
Regards,
Horacio Carvajal