2

Resolved

Error on PersianDateT.sql

description

There is a problem with PersianDateT.sql script,
here 's an output when i run it:
 
*Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
Msg 102, Level 15, State 1, Line 22
Incorrect syntax near '.'.*
 
it points to somewhere in the comment section, That's wierd

file attachments

comments

dNetGuru wrote Nov 3, 2008 at 9:10 PM

The problem is cause by a last minute addition to PersianDateT.sql right before being uploaded !
Add a semicolon right after the "DateTime.GetString(1)" on 78th line resulting :

SELECT ID, DateTime.GetString(1), DateTime.DayOfWeek AS DoW FROM dbo.Main WHERE (DateTime.Hour = 15 AND DateTime.Second = 17) OR DateTime.Year = 1368

An updated file is Attached, Will be fixed in the upcoming release.

wrote Nov 3, 2008 at 9:10 PM

wrote Feb 13, 2013 at 1:02 AM

wrote May 15, 2013 at 5:03 AM

wrote May 15, 2013 at 5:03 AM

wrote Jun 12, 2013 at 1:50 AM