Subject | Re: [IBO] Searching within a TIB_Query using Locate? |
---|---|
Author | Chris at Visible Changes |
Post date | 2000-12-12T20:17:11Z |
Thanks again Jason for your great response time. As instructed I dropped
the TIB_MonitorDialog control on the form and the message is below:
NOTE: The JOB_CLASS table contains Array type fields DEDUCTIONS,EARNINGS as
integers of 30 elements. I do not know if this has anything to do with my
problem or not.
SQL Monitor output is as follows:
/*---
PREPARE STATEMENT
TR_HANDLE = 51955052
STMT_HANDLE = 52003252
SELECT * FROM JOB_CLASS
WHERE JOB_CLASS.ID=? /* BIND_0 */
;
FOR UPDATE
FIELDS = [ Version 1 SQLd 6 SQLn 6
JOB_CLASS.ID = <n> 0
JOB_CLASS.NAME = <n> ''
JOB_CLASS.SHORT_NAME = <n> ''
JOB_CLASS.DEDUCTIONS = <NULL>
JOB_CLASS.EARNINGS = <NULL>
JOB_CLASS.NOTES = <NULL> ]
SECONDS = 0.024
ERRCODE = 335544569
----*/
/*---
INTERPRETE BUFFER =
SECONDS = 0.041
ERRCODE = 17
----*/
/*---
INTERPRETE BUFFER = Dynamic SQL Error
ERRCODE = 21
----*/
/*---
INTERPRETE BUFFER = SQL error code = -104
ERRCODE = 31
----*/
/*---
INTERPRETE BUFFER = Token unknown - line 5, char -1
ERRCODE = 3
----*/
/*---
INTERPRETE BUFFER = FOR
ERRCODE = -1
----*/
/*---
COMMIT
TR_HANDLE = 52058896
----*/
Chris Hulsey
Visible Changes, Inc.
chulsey@...
the TIB_MonitorDialog control on the form and the message is below:
NOTE: The JOB_CLASS table contains Array type fields DEDUCTIONS,EARNINGS as
integers of 30 elements. I do not know if this has anything to do with my
problem or not.
SQL Monitor output is as follows:
/*---
PREPARE STATEMENT
TR_HANDLE = 51955052
STMT_HANDLE = 52003252
SELECT * FROM JOB_CLASS
WHERE JOB_CLASS.ID=? /* BIND_0 */
;
FOR UPDATE
FIELDS = [ Version 1 SQLd 6 SQLn 6
JOB_CLASS.ID = <n> 0
JOB_CLASS.NAME = <n> ''
JOB_CLASS.SHORT_NAME = <n> ''
JOB_CLASS.DEDUCTIONS = <NULL>
JOB_CLASS.EARNINGS = <NULL>
JOB_CLASS.NOTES = <NULL> ]
SECONDS = 0.024
ERRCODE = 335544569
----*/
/*---
INTERPRETE BUFFER =
SECONDS = 0.041
ERRCODE = 17
----*/
/*---
INTERPRETE BUFFER = Dynamic SQL Error
ERRCODE = 21
----*/
/*---
INTERPRETE BUFFER = SQL error code = -104
ERRCODE = 31
----*/
/*---
INTERPRETE BUFFER = Token unknown - line 5, char -1
ERRCODE = 3
----*/
/*---
INTERPRETE BUFFER = FOR
ERRCODE = -1
----*/
/*---
COMMIT
TR_HANDLE = 52058896
----*/
Chris Hulsey
Visible Changes, Inc.
chulsey@...