Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.05 » View Incident Report |
Minor |
Reported By: Terry Swiers Reported On: 6/28/2011 For: Version 2.05 Build 9 |
SCRIPT BEGIN DECLARE TableCheckCursor CURSOR for TableCheck; -- Create the work table after first checking for and dropping it if it exists PREPARE TableCheck FROM ' Select * From information.TemporaryTables Where Name = ? '; BEGIN OPEN TableCheckCursor using 'UTBidImport'; IF RowCount(TableCheckCursor) > 0 then EXECUTE IMMEDIATE 'Drop Table UTBidImport'; END IF; CLOSE TableCheckCursor; EXCEPTION END; EXECUTE IMMEDIATE ' Create Temporary Table "UTBidImport" ( "BidGUID" VARCHAR(38) COLLATE "UNI" DEFAULT ''{8470740F-5D17-41EF-8709-ABC583D597C7}'', "StockCode" VARCHAR(20) COLLATE "UNI", "Amount" INTEGER DEFAULT 0 ) '; -- Load the work table from the text file EXECUTE IMMEDIATE ' Import Table UTBidImport from "UTBidPrice.txt" In Store "Temp" (StockCode, Amount) Delimiter Char #9 '; END
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 |