ZQuery Locate

[nostradumbass]

Using:
Delphi 2007 Enterprise
Zeos DBO 6.6.6 Stable
Firbird 2.1

Have ZQuery with SQL property set to:

Code: Select all

SELECT 
 ORDERID,
 ORDERNAME
FROM ORDERS_LIST ( :ORDCMPSTATUS ); 

IndexFieldNames property set to:

Code: Select all

ORDERID Asc

where ORDERS_LIST is a stored procedure in the database. ORDERID field is indexed in the source table.



In Delphi code:

Code: Select all

with datamod.ZQRY_ORDERS_LIST do
    if Locate('ORDERID', VarArrayOf([OrderID]), []) then
      showmessage('found!');

Is not working!!

Is it because the source is a stored procedure and not a table?