OK, I upgraded to FC 4.10 and attempted to deploy the tables using Admin->COAPI Tools->Type Classes
I was able to deploy farVerityLog but ran into a bug when I tried to deploy farVerityCollection... The SQL query that is being run: CREATE TABLE DBO.farVerityCollection( bEnableSearch [int] default 0 NULL , builttodate [DATETIME] default 01-JAN-70 NOT NULL , catCollection [VARCHAR] (255) NULL , collectionname [VARCHAR] (255) NULL , collectionpath [VARCHAR] (255) NULL , collectiontype [VARCHAR] (255) NULL , collectiontypename [VARCHAR] (255) NULL , createdby [NVARCHAR] (512) NOT NULL , custom3 [VARCHAR] (255) NULL , custom4 [VARCHAR] (255) NULL , datetimecreated [DATETIME] NOT NULL , datetimelastupdated [DATETIME] NOT NULL , fileproperty [VARCHAR] (255) NULL , hostname [VARCHAR] (255) NULL , indexTitle [VARCHAR] (255) NULL , label [NVARCHAR] (512) NULL , lastupdatedby [NVARCHAR] (512) NOT NULL , lIndexProperties [NTEXT] NULL , locked [int] default 0 NOT NULL , lockedBy [NVARCHAR] (512) NULL , ObjectID [VARCHAR] (50) NOT NULL , ownedby [NVARCHAR] (512) NULL , title [VARCHAR] (255) NULL ,PRIMARY KEY (ObjectID) ); The error message that SQL Server is returning: The name 'JAN' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. What is the best way to fix this issue so that the original bug is corrected? Thanks, Bill Poff SiteVision --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev?hl=en -~----------~----~----~----~------~----~------~--~---
