--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...> wrote:

> I think I see that you had a bunch of ------ separating the script and I
> didn't catch that. I've got a clean build of your database I believe.
>
> I'd like to see the SQL trace of the problem too.
>
> Drop a TIB_MonitorDialog component on your main form and call the Show
> method if it. Run your app and then scrape out the text in it.
>
> Also, paste in the DFM text of your TIBOTable.
>
> Were you messing around with any schema caching that may need to be
> refreshed?
>
> Jason Wharton

Here is the relevant stuff from the DFM

object IBODatabase1: TIBODatabase
Params.Strings = (
'PROTOCOL=TCP/IP'
'SERVER=172.16.0.5'
'PATH=C:\data\epos.fdb'
'USER NAME=EPOS')
Left = 63
Top = 44
SavedPassword = '.JuMbLe.01.597B1B2A067D0B49'
end
object IBOTable1: TIBOTable
DatabaseName = '172.16.0.5:C:\data\epos.fdb'
IB_Connection = IBODatabase1
RecordCountAccurate = True
TableName = 'WORKING'
FieldOptions = []
Left = 150
Top = 45

Here is the SQL Trace

/*---
CONNECT DATABASE 172.16.0.5:C:\data\epos.fdb
DB_HANDLE = 14840328

SECONDS = 0.811
----*/
/*---
DATABASE INFO
DB_HANDLE = 14840328

SECONDS = 0.010
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14839800
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839896

/* OldParameterOrder test query */
SELECT R.RDB$RELATION_NAME,
(SELECT RDB$FIELD_NAME
FROM RDB$RELATION_FIELDS F
WHERE F.RDB$RELATION_NAME=R.RDB$RELATION_NAME
AND F.RDB$FIELD_POSITION=? /* PRM_0 */ ) AS TESTFIELD
FROM RDB$RELATIONS R
WHERE R.RDB$RELATION_NAME=? /* PRM_1 */

PLAN (R INDEX (RDB$INDEX_0))
PLAN (F INDEX (RDB$INDEX_4))

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$RELATIONS.RDB$RELATION_NAME = <NIL>
[TESTFIELD] = <NIL> ]

SECONDS = 0.080
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14839704

SECONDS = 0.010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488

SELECT S.RDB$FIELD_NAME
, I.RDB$RELATION_NAME
FROM RDB$RELATION_CONSTRAINTS C
, RDB$INDICES I
, RDB$INDEX_SEGMENTS S
WHERE C.RDB$CONSTRAINT_TYPE = 'PRIMARY KEY'
AND C.RDB$RELATION_NAME = I.RDB$RELATION_NAME
AND C.RDB$INDEX_NAME = I.RDB$INDEX_NAME
AND I.RDB$INDEX_NAME = S.RDB$INDEX_NAME
ORDER BY I.RDB$RELATION_NAME ASC
, S.RDB$FIELD_POSITION ASC

PLAN SORT (JOIN (C NATURAL,I INDEX (RDB$INDEX_5),S INDEX (RDB$INDEX_6)))

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = <NIL>
RDB$INDICES.RDB$RELATION_NAME = <NIL> ]

SECONDS = 0.070
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ ]

SECONDS = 0.010
----*/
/*---
COMMIT
TR_HANDLE = 14839800
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14839800

SECONDS = 0.010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488

SELECT RDB$FIELD_NAME
FROM RDB$INDEX_SEGMENTS
WHERE RDB$INDEX_NAME = ? /* Name */
ORDER BY RDB$FIELD_POSITION ASC

PLAN SORT ((RDB$INDEX_SEGMENTS INDEX (RDB$INDEX_6)))

FIELDS = [ Version 1 SQLd 1 SQLn 30
RDB$INDEX_SEGMENTS.RDB$FIELD_NAME = <NIL> ]

SECONDS = 0.060
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14828936

SELECT I.RDB$RELATION_NAME
, I.RDB$INDEX_NAME
, I.RDB$UNIQUE_FLAG
, I.RDB$INDEX_TYPE
, I.RDB$FOREIGN_KEY
, ( SELECT C.RDB$CONSTRAINT_NAME
FROM RDB$RELATION_CONSTRAINTS C
WHERE C.RDB$INDEX_NAME = I.RDB$INDEX_NAME ) AS CNST
, ( SELECT R.RDB$UPDATE_RULE
FROM RDB$REF_CONSTRAINTS R
WHERE R.RDB$CONSTRAINT_NAME =
( SELECT C.RDB$CONSTRAINT_NAME
FROM RDB$RELATION_CONSTRAINTS C
WHERE C.RDB$INDEX_NAME = I.RDB$INDEX_NAME )) AS UR
, ( SELECT R.RDB$DELETE_RULE
FROM RDB$REF_CONSTRAINTS R
WHERE R.RDB$CONSTRAINT_NAME =
( SELECT C.RDB$CONSTRAINT_NAME
FROM RDB$RELATION_CONSTRAINTS C
WHERE C.RDB$INDEX_NAME = I.RDB$INDEX_NAME )) AS DR
FROM RDB$INDICES I
WHERE NOT I.RDB$RELATION_NAME STARTING WITH 'RDB$'

PLAN (I NATURAL)
PLAN (C INDEX (RDB$INDEX_43))
PLAN (R INDEX (RDB$INDEX_13))
PLAN (C INDEX (RDB$INDEX_43))
PLAN (R INDEX (RDB$INDEX_13))
PLAN (C INDEX (RDB$INDEX_43))

FIELDS = [ Version 1 SQLd 8 SQLn 30
RDB$INDICES.RDB$RELATION_NAME = <NIL>
RDB$INDICES.RDB$INDEX_NAME = <NIL>
RDB$INDICES.RDB$UNIQUE_FLAG = <NIL>
RDB$INDICES.RDB$INDEX_TYPE = <NIL>
RDB$INDICES.RDB$FOREIGN_KEY = <NIL>
[CNST] = <NIL>
[UR] = <NIL>
[DR] = <NIL> ]

SECONDS = 0.070
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14828936
PARAMS = [ ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_LOG ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY2 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'USER_ID6 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PRODUCT_ID3 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'SALESQUANTITY4 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'TID5 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'RDB$PRIMARY1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'TID2 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PRODUCT_ID1 ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_USER_STATS ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_MESSAGES ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_USERS ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_SUPPLIERS ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_STOCK_ORDERS ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_STOCK_ORDER_DETAILS ' ]
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_STOCK ' ]

SECONDS = 0.010
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839800
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 1 SQLn 1
[NAME] = 'PK_WORKING ' ]

SECONDS = 0.010
----*/
/*---
COMMIT
TR_HANDLE = 14839800

SECONDS = 0.010
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14839840

SECONDS = 0.010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839840
STMT_HANDLE = 14839488

SELECT RDB$PROCEDURE_NAME
FROM RDB$PROCEDURES
ORDER BY RDB$PROCEDURE_NAME ASC

PLAN (RDB$PROCEDURES ORDER RDB$INDEX_21)

FIELDS = [ Version 1 SQLd 1 SQLn 30
RDB$PROCEDURES.RDB$PROCEDURE_NAME = <NIL> ]

SECONDS = 0.060
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839840
STMT_HANDLE = 14839488
PARAMS = [ ]
----*/
/*---
COMMIT
TR_HANDLE = 14839840
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839704
STMT_HANDLE = 14839896

SELECT ALL WORKING.*
FROM WORKING
ORDER BY WORKING.UID ASC

PLAN (WORKING ORDER PK_WORKING)

FIELDS = [ Version 1 SQLd 4 SQLn 30
WORKING.UID = <NIL>
WORKING.START = <NIL>
WORKING.FINISH = <NIL>
WORKING.ONDATE = <NIL> ]

SECONDS = 0.060
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14828768

SECONDS = 0.010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14828768
STMT_HANDLE = 14839488

SELECT R.RDB$FIELD_NAME
, R.RDB$RELATION_NAME
FROM RDB$RELATION_FIELDS R, RDB$FIELDS F
WHERE R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME
AND F.RDB$COMPUTED_SOURCE IS NOT NULL
AND NOT R.RDB$RELATION_NAME STARTING WITH 'RDB$'
ORDER BY 1 ASC

PLAN SORT (JOIN (F NATURAL,R INDEX (RDB$INDEX_3)))

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME = <NIL> ]

SECONDS = 0.070
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14828768
STMT_HANDLE = 14839488
PARAMS = [ ]

SECONDS = 0.010
----*/
/*---
COMMIT
TR_HANDLE = 14828768
----*/
/*---
START TRANSACTION
DB HANDLE COUNT 1
TR_HANDLE = 14829012

SECONDS = 0.010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14829012
STMT_HANDLE = 14839488

SELECT F.RDB$FIELD_NAME F_FieldName
, F.RDB$RELATION_NAME F_RelationName
, F.RDB$DEFAULT_SOURCE F_DefaultSource
, D.RDB$DEFAULT_SOURCE D_DefaultSource
, D.RDB$FIELD_TYPE D_FieldType
FROM RDB$RELATION_FIELDS F
INNER JOIN RDB$FIELDS D
ON D.RDB$FIELD_NAME = F.RDB$FIELD_SOURCE
WHERE (( F.RDB$DEFAULT_SOURCE IS NOT NULL ) OR ( D.RDB$DEFAULT_SOURCE
IS NOT NULL ))
AND NOT F.RDB$RELATION_NAME STARTING WITH 'RDB$'
ORDER BY 1 ASC

PLAN SORT (JOIN (F NATURAL,D INDEX (RDB$INDEX_2)))

FIELDS = [ Version 1 SQLd 5 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME[F_FIELDNAME] = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME[F_RELATIONNAME] = <NIL>
RDB$RELATION_FIELDS.RDB$DEFAULT_SOURCE[F_DEFAULTSOURCE] = <NIL>
RDB$FIELDS.RDB$DEFAULT_SOURCE[D_DEFAULTSOURCE] = <NIL>
RDB$FIELDS.RDB$FIELD_TYPE[D_FIELDTYPE] = <NIL> ]

SECONDS = 0.061
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14829012
STMT_HANDLE = 14839488
PARAMS = [ ]

SECONDS = 0.040
----*/
/*---
COMMIT
TR_HANDLE = 14829012
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839704
STMT_HANDLE = 14839896
PARAMS = [ ]

SECONDS = 0.010
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 14839704
STMT_HANDLE = 14839488

UPDATE WORKING
SET UID = ? /* UID */ << Could this be my problem ?
, START = ? /* START */
, FINISH = ? /* FINISH */
, ONDATE = ? /* ONDATE */
WHERE WORKING.UID = ? /* OLD.UID */

PLAN (WORKING INDEX (PK_WORKING))

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]

SECONDS = 0.060
----*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 14839704
STMT_HANDLE = 14839488
PARAMS = [ Version 1 SQLd 5 SQLn 5
WORKING.UID = 1
WORKING.START = '14:23:21 7980'
WORKING.FINISH = '22:59:37 8690'
WORKING.ONDATE = '01 Nov 2004'
WORKING.UID[UID] = 1 ]

SECONDS = 0.010

ERRCODE = 335544652
----*/
/*---
INTERPRET BUFFER =

ERRCODE = 33
----*/
/*---
INTERPRET BUFFER = multiple rows in singleton select

ERRCODE = -1
----*/

Do you want to do this via e-mail ? I keep missing posts from you
whilst replying to the previous one!

Cheers

Trevor