Subject | Re: [IBO] Locate doesn't work on TIBOQuery? |
---|---|
Author | Daniel Rail |
Post date | 2004-03-04T22:53:34Z |
Hi,
At March 4, 2004, 18:44, ra8009 wrote:
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At March 4, 2004, 18:44, ra8009 wrote:
> I use a locate using a partial key against a query like the one belowWhich version of IBO are you using?
> 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?
--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)