Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Addressed for Version 4.22 » View Incident Report |
Minor |
Reported By: Ralf Mimoun Reported On: 2/9/2006 For: Version 4.22 Build 4 |
CREATE TABLE IF NOT EXISTS "a" ( "id" AUTOINC, "name" VARCHAR(10), PRIMARY KEY ("RecordID") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 LAST AUTOINC 3 ); INSERT INTO "a" VALUES (1, 'AA'); INSERT INTO "a" VALUES (2, 'AB'); INSERT INTO "a" VALUES (3, 'AC'); CREATE TABLE IF NOT EXISTS "B" ( "ID" AUTOINC, "A_ID" INTEGER, "V" INTEGER, PRIMARY KEY ("RecordID") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 LAST AUTOINC 6 ); INSERT INTO "B" VALUES (1, 1, 1); INSERT INTO "B" VALUES (2, 1, 1); INSERT INTO "B" VALUES (3, 1, 1); INSERT INTO "B" VALUES (4, 2, 1); INSERT INTO "B" VALUES (5, 2, 1); INSERT INTO "B" VALUES (6, 3, 1); SELECT A.*, 0 AS SumB INTO "MEMORY\Tmp" FROM A; UPDATE "MEMORY\Tmp" SET SumB = SumB + B.V FROM "MEMORY\Tmp" INNER JOIN B ON B.A_ID = "MEMORY\Tmp".ID; SELECT * FROM "MEMORY\Tmp";
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |