Subject | Global Temporary Tables |
---|---|
Author | |
Post date | 2014-02-06T23:28:11Z |
I have a table defined as follows:
CREATE GLOBAL TEMPORARY TABLE TEMPTBL
(
REF1 Integer NOT NULL,
REF2 Integer NOT NULL,
DESC Varchar(30),
PRIMARY KEY (REF1,REF2)
);
I have a TIBOQuery supplying the data to a TDBGrid, which is user-editable. If I insert then delete a row, I get the error "Record was not located to delete". Similarly if I try and edit a previously inserted row I get "Record was not located to update" on posting. Keylinks on the query are set correctly, the primary key fields are set by the client (i.e. not by a trigger on the server) and I can't think of what else to check. If I use an identical table but not defined as "GLOBAL TEMPORARY" I don't get any error.
Can you advise please? Thanks in advance.
CREATE GLOBAL TEMPORARY TABLE TEMPTBL
(
REF1 Integer NOT NULL,
REF2 Integer NOT NULL,
DESC Varchar(30),
PRIMARY KEY (REF1,REF2)
);
I have a TIBOQuery supplying the data to a TDBGrid, which is user-editable. If I insert then delete a row, I get the error "Record was not located to delete". Similarly if I try and edit a previously inserted row I get "Record was not located to update" on posting. Keylinks on the query are set correctly, the primary key fields are set by the client (i.e. not by a trigger on the server) and I can't think of what else to check. If I use an identical table but not defined as "GLOBAL TEMPORARY" I don't get any error.
Can you advise please? Thanks in advance.