ZQuery Locate
Posted: 10.06.2010, 13:51
Using:
Delphi 2007 Enterprise
Zeos DBO 6.6.6 Stable
Firbird 2.1
Have ZQuery with SQL property set to:
IndexFieldNames property set to:
where ORDERS_LIST is a stored procedure in the database. ORDERID field is indexed in the source table.
In Delphi code:
Is not working!!
Is it because the source is a stored procedure and not a table?
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 );
Code: Select all
ORDERID AscIn Delphi code:
Code: Select all
with datamod.ZQRY_ORDERS_LIST do
if Locate('ORDERID', VarArrayOf([OrderID]), []) then
showmessage('found!');
Is it because the source is a stored procedure and not a table?