EXECUTE IMMEDIATE 
'CREATE TABLE "SCTESTVER"
(
"App" VARCHAR(14) COLLATE "ANSI" NOT NULL,
"Ver" INTEGER NOT NULL,
"ExecOrder" SMALLINT NOT NULL,
"Info" CLOB COLLATE "ANSI" NOT NULL,
"UserCanSkip" BOOLEAN NOT NULL,
"Path" VARCHAR(255) COLLATE "ANSI" NOT NULL,
"Destination" VARCHAR(255) COLLATE "ANSI" NOT NULL,
"Kind" SMALLINT NOT NULL
)
DESCRIPTION ''Actualitzacions automàtiques per C/S,
no cal tenir unitat ni UNC per fer-ho funcionar.''
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
PUBLISH BLOCK SIZE 512
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768';


EXECUTE IMMEDIATE 
'ALTER TABLE "SCTESTVER"
ADD CONSTRAINT "PrimaryKey" PRIMARY KEY ("App", "Ver", "ExecOrder")';

EXECUTE IMMEDIATE 
'CREATE TRIGGER "SCTESTVER_BeforeInsert" BEFORE INSERT ON "SCTESTVER"
BEGIN
  SET NEWROW.App = NULLIF(TRIM(BOTH '' '' FROM UPPER(NEWROW.App)),'''');
END
';

   
   EXECUTE IMMEDIATE 
'CREATE TRIGGER "SCTESTVER_BeforeUpdate" BEFORE UPDATE ON "SCTESTVER"
BEGIN
  SET NEWROW.App = NULLIF(TRIM(BOTH '' '' FROM UPPER(NEWROW.App)),'''');
END';
   

---

 Comments

---

This issue was due to the fact that the engine was not clearing the internal BLOB offsets properly when the row was copied. Therefore, multiple rows were sharing the same BLOB offsets, and modifying one row would affect the other. If you experienced this issue, then contact us for information on how to fix the affected rows.

---

 Resolution

---

Fixed Problem on 3/20/2009 in version 2.02 build 11

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial