Subject Re: [IBO] Searching within a TIB_Query using Locate?
Author Chris at Visible Changes
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@...