Subject Global Temporary Tables
Author
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.