On Mar 26, 11:39 am, Bill Poff <[EMAIL PROTECTED]> wrote: > 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 , > ...snip...8<... > > 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?
Looks like your database doesn't like the way the default value is being nominated for builttodate. What database type and version are you using? -- geoff http://www.daemon.com.au/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
