Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.03 » View Incident Report |
Serious |
Reported By: Piotr Font Reported On: 1/14/2010 For: Version 2.03 Build 7 |
SELECT File.FileID, FileDictionary."Name" FROM File INNER JOIN FileDictionary ON File.FileDictionaryID = FileDictionary.FileDictionaryID WHERE ( NodeId=1228 ) AND (File.Deleted = false) AND (File.UserActivity = false) ORDER BY FileDictionary."Name" Table: CREATE TABLE "FileDictionary" ( "FileDictionaryID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 0, INCREMENT BY 1), "Name" VARCHAR(256) COLLATE "UNI_CI", "Version" VARCHAR(256) COLLATE "UNI_CI", "Size" BIGINT, "CompanyDictionaryID" INTEGER, "Description" VARCHAR(256) COLLATE "UNI_CI", "ProductName" VARCHAR(256) COLLATE "UNI_CI", "OriginalFileName" VARCHAR(256) COLLATE "UNI_CI", "Icon" BLOB ) VERSION 2 UNENCRYPTED INDEX PAGE SIZE 5288 BLOB BLOCK SIZE 2256 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
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 |