Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.14 » View Incident Report |
Serious |
Reported By: David Cornelius Reported On: 11/17/2004 For: Version 4.14 Build 1 |
INSERT INTO SamplesSentDetl SELECT LastAutoInc('SamplesSent'), ProdId, Product, PackType, ProdDesc, Package, UnitSize, Unit, Price FROM AvailPrd WHERE ItemId = :ItemId The definitions of the 3 tables used are listed below for reference (minus the indexes): CREATE TABLE IF NOT EXISTS "Availprd" ( "ItemId" AUTOINC, "ProdId" INTEGER, "Product" VARCHAR(30), "PackType" VARCHAR(30), "VendId" INTEGER, "CustId" INTEGER, "SalesId" INTEGER, "AddrId" INTEGER, "Date" DATE, "ProdDesc" VARCHAR(70), "Package" VARCHAR(15), "UnitSize" INTEGER, "Unit" VARCHAR(5), "Price" FLOAT, "Qty" INTEGER, "Wanted" SMALLINT, "Hot" SMALLINT, "Spot" BOOLEAN, "SampleSent" DATE, "ProductNotes" VARCHAR(200), "DateCreated" TIMESTAMP DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ("ItemId") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 ); CREATE TABLE IF NOT EXISTS "SamplesSent" ( "ItemId" AUTOINC NOT NULL, "DateRequested" DATE DEFAULT CURRENT_DATE, "SampleSent" DATE, "ProdId" INTEGER, "Product" VARCHAR(30), "PackType" VARCHAR(30), "VendId" INTEGER, "Vendor" VARCHAR(30), "CustId" INTEGER, "Customer" VARCHAR(30), "SalesId" INTEGER, "ProdDesc" VARCHAR(70), "Package" VARCHAR(6), "UnitSize" SMALLINT, "Unit" VARCHAR(5), "Price" MONEY, "Received" DATE, "ReceivedBy" VARCHAR(15), "PrintingNotes" MEMO, "InternalNotes" MEMO, PRIMARY KEY ("ItemId") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 ); CREATE TABLE IF NOT EXISTS "SamplesSentDetl" ( "ItemId" INTEGER NOT NULL, "ProdId" INTEGER NOT NULL, "Product" VARCHAR(30), "PackType" VARCHAR(30), "ProdDesc" VARCHAR(70), "Package" VARCHAR(15), "UnitSize" SMALLINT, "Unit" VARCHAR(5), "Price" MONEY, PRIMARY KEY ("RecordID") COMPRESS NONE LOCALE CODE 0 USER MAJOR VERSION 1 );
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |