Subject Re: [IBO] Searching within a TIB_Query using Locate?
Author Jason Wharton
Did you set searchededits to false?

Just curious...

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com


----- Original Message -----
From: "Chris at Visible Changes" <chulsey@...>
To: <IBObjects@egroups.com>
Sent: Tuesday, December 12, 2000 1:17 PM
Subject: Re: [IBO] Searching within a TIB_Query using Locate?


> 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@...
>
>
>
>
>