Subject Re: [IBO] Locate says unknown token
Author Don Gollahon
I put quotes around the field "DAY" in the keylinks and now the error is in
the parameter on line 3 instead of the first line. How do I fix that?

/*---

[ 11/30/2001 8:43:22 PM ]

PREPARE STATEMENT

TR_HANDLE = 10638804

STMT_HANDLE = 10631352

SELECT SERVICES."DAY", SERVICES.SRVC_TIME

FROM SERVICES

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

FIELDS = [ Version 1 SQLd 2 SQLn 30

ID = <NIL>

[NUM_EXCLUSIONS] = <NIL> ]

SECONDS = 0.050

ERRCODE = 335544569

----*/

/*---

[ 11/30/2001 8:43:22 PM ]

PREPARE STATEMENT

TR_HANDLE = 10638804

STMT_HANDLE = 10631352

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:43:22 PM ]

INTERPRETE BUFFER =

SECONDS = 0.210

ERRCODE = 17

----*/

/*---

[ 11/30/2001 8:43:23 PM ]

INTERPRETE BUFFER = Dynamic SQL Error

ERRCODE = 21

----*/

/*---

[ 11/30/2001 8:43:23 PM ]

INTERPRETE BUFFER = SQL error code = -104

ERRCODE = 31

----*/

/*---

[ 11/30/2001 8:43:23 PM ]

INTERPRETE BUFFER = Token unknown - line 3, char 17

ERRCODE = 3

----*/

/*---

[ 11/30/2001 8:43:23 PM ]

INTERPRETE BUFFER = DAY

ERRCODE = -1

----*/

/*---

[ 11/30/2001 8:43:23 PM ]

EXECUTE STATEMENT

TR_HANDLE = 10638804

STMT_HANDLE = 14360692

PARAMS = [ ]

----*/