Subject | Re: [IBO] Locate says unknown token |
---|---|
Author | Don Gollahon |
Post date | 2001-12-01T02:44:17Z |
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 = [ ]
----*/
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 = [ ]
----*/