Subject | Locate fails with "no index error"?? |
---|---|
Author | G. Allen Casteran |
Post date | 2002-01-28T21:39:50Z |
I am trying to do a Locate() on a TIBOQuery Result with the following statement
const KeyWanted = 4;
SelQry.Locate('PKey', KeyWanted, []);
I set a whole list of OrderingItems in the SQL Editor and set the
OrderingItem to 1 to pick the first one (same as the field I am trynig to
locate).
So why does the SQLOrderingItems have an empty list when I try to seek the key?
Thanks,
Allen.
I just noticed that my Query is empty.
Is that the sole cause and if there are rows present then the locate will work?
const KeyWanted = 4;
SelQry.Locate('PKey', KeyWanted, []);
I set a whole list of OrderingItems in the SQL Editor and set the
OrderingItem to 1 to pick the first one (same as the field I am trynig to
locate).
So why does the SQLOrderingItems have an empty list when I try to seek the key?
Thanks,
Allen.
I just noticed that my Query is empty.
Is that the sole cause and if there are rows present then the locate will work?