I have an IBOQuery that seems to work fine except for the locate command.
When the locate executes I get the following in the monitor saying invalid
token. The problem is probably that one of the key fields has the name
"DAY" which may be a key word in IB dialect 3 (I've converted this app from
Paradox tables).

I'm using Delphi 4 Prof, IBO 4.2 Fa.

Here is a portion of the monitor display:
[ 11/30/2001 8:07:38 PM ]

PREPARE STATEMENT

TR_HANDLE = 10705004

STMT_HANDLE = 10697548

SELECT SERVICES.DAY, SERVICES.SRVC_TIME

FROM SERVICES

WHERE (((SERVICES.DAY = ? /* PRM_0 */ )))

FIELDS = [ Version 1 SQLd 2 SQLn 30

ID = <NIL>

[NUM_EXCLUSIONS] = <NIL> ]

ERRCODE = 335544569

----*/

/*---

[ 11/30/2001 8:07:38 PM ]

INTERPRETE BUFFER =

SECONDS = 0.140

ERRCODE = 17

----*/

/*---

[ 11/30/2001 8:07:38 PM ]

INTERPRETE BUFFER = Dynamic SQL Error

ERRCODE = 21

----*/

/*---

[ 11/30/2001 8:07:38 PM ]

INTERPRETE BUFFER = SQL error code = -104

ERRCODE = 31

----*/

/*---

[ 11/30/2001 8:07:38 PM ]

INTERPRETE BUFFER = Token unknown - line 1, char 16

ERRCODE = 3

----*/

/*---

[ 11/30/2001 8:07:38 PM ]

INTERPRETE BUFFER = DAY

ERRCODE = -1

----*/

/*---

[ 11/30/2001 8:07:39 PM ]

EXECUTE STATEMENT

TR_HANDLE = 10705004

STMT_HANDLE = 14426244

PARAMS = [ ]

----*/


--

Don Gollahon
(dlgllhn@...)