Subject | Locate doesn't work on TIBOQuery? |
---|---|
Author | ra8009 |
Post date | 2004-03-04T22:44:01Z |
I use a locate using a partial key against a query like the one below
using a TIBOQuery. Most of the time, I get a "Token unknown" error
listing _NAME as the problem. Here's what shows up in the Monitor Log:
INTERPRETE BUFFER = _NAME
ERRCODE = -1
Here's the SQL:
SELECT
Customer_ID,
Last_Name,
First_Name,
Cust_Active,
((Last_Name||', ')||First_Name) as Name
FROM Custinfo C
where
Cust_Active = :Status
I'm running against Firebird 1.5. What could be wrong?
using a TIBOQuery. Most of the time, I get a "Token unknown" error
listing _NAME as the problem. Here's what shows up in the Monitor Log:
INTERPRETE BUFFER = _NAME
ERRCODE = -1
Here's the SQL:
SELECT
Customer_ID,
Last_Name,
First_Name,
Cust_Active,
((Last_Name||', ')||First_Name) as Name
FROM Custinfo C
where
Cust_Active = :Status
I'm running against Firebird 1.5. What could be wrong?