View Single Post
Old 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.
Grennvicted is offline   Reply With Quote