hello

i am working in DotNetNuke 4.3.6 with VS 2005 . i have following procedure in script file of  my project.which creating problem when i make installer for my project.please help me in this.



CREATE procedure {databaseOwner}{objectQualifier}Nta_AddSurveyResult

@SurveyOptionID  int,
@UserID          int,
@ProcessStatus nvarchar(50)
as

update {objectQualifier}NtaSurveyOptions
set    Votes = Votes + 1
where  SurveyOptionID = @SurveyOptionID

insert into {objectQualifier}NtaSurveyResults ( SurveyOptionID, UserID,CurrentProcessState )
values ( @SurveyOptionID, @UserID,@ProcessStatus )

select SCOPE_IDENTITY()
GO

Error which i recieve is :

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 12: Incorrect syntax near '1'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) CREATE procedure dbo.Nta_AddSurveyResult @SurveyOptionID int, @UserID int, @ProcessStatus nvarchar(50) as update NtaSurveyOptions set Votes = Votes 1 where SurveyOptionID = @SurveyOptionID insert into NtaSurveyResults ( SurveyOptionID, UserID,CurrentProcessState ) values ( @SurveyOptionID, @UserID,@ProcessStatus ) select SCOPE_IDENTITY()

you can  see it remove  + sign between Votes column and 1 which creates an error.

i also try this .removing space between Votes column and + sign and  between + sign and 1.this excute succcess fully but remove this "+ 1" from procedure.

CREATE procedure {databaseOwner}{objectQualifier}Nta_AddSurveyResult

@SurveyOptionID  int,
@UserID          int,
@ProcessStatus nvarchar(50)
as

update {objectQualifier}NtaSurveyOptions
set    Votes = Votes+1
where  SurveyOptionID = @SurveyOptionID

insert into {objectQualifier}NtaSurveyResults ( SurveyOptionID, UserID,CurrentProcessState )
values ( @SurveyOptionID, @UserID,@ProcessStatus )

select SCOPE_IDENTITY()
GO

Thanx, as i save my file in UTF-8 format and execute my module. it worked fine.