Winamp & Shoutcast Forums - View Single Post

Grennvicted · 11th September 2010, 23:51

In NSIS

code:


//Insert code that works

MSSQL_OLEDB::SQL_ExecuteScript "InsertIntoMyTable.sql"



Sleep 10000

//Deletion query

MSSQL_OLEDB::SQL_ExecuteScript "ModifyMyTable.sql"

MSSQL_OLEDB::SQL_GetError

//error Message

The Deletion query that works in MS SQL

code:


Delete From MyTable

Where (Id>1 Or Id =1) And (Id>5 or Id=5) And (otherStuffId=5 And OtherStuffId=6)

The Id is a primary key and i want to delete the 2 rows of each Id where otherStuffId=5 and otherStuffId=6

The deletion query return an error message (with NSIS) that's what i do not understand.
I'm workin with Ms SQL express 2005.

11th September 2010, 23:51	#3
Grennvicted Junior Member Join Date: Sep 2010 Posts: 8	In NSIS code: //Insert code that works MSSQL_OLEDB::SQL_ExecuteScript "InsertIntoMyTable.sql" Sleep 10000 //Deletion query MSSQL_OLEDB::SQL_ExecuteScript "ModifyMyTable.sql" MSSQL_OLEDB::SQL_GetError //error Message The Deletion query that works in MS SQL code: Delete From MyTable Where (Id>1 Or Id =1) And (Id>5 or Id=5) And (otherStuffId=5 And OtherStuffId=6) The Id is a primary key and i want to delete the 2 rows of each Id where otherStuffId=5 and otherStuffId=6 The deletion query return an error message (with NSIS) that's what i do not understand. I'm workin with Ms SQL express 2005.