Re: [WiX-users] Insert error

2008-10-04 Thread Richard
Error 2259 is "2259 Database: [2] Table(s) Update failed. Queries must adhere to the restricted Windows Installer SQL syntax." Try using wirunsql.vbs to validate that your query is using the correct syntax. I don't see anything obviously wrong with your query, but if you can't get it work in wi

Re: [WiX-users] Insert error

2008-10-04 Thread Powell, Simon
I'm not using it in a custom action. I was testing the ability to INSERT a row. -Original Message- From: Richard [mailto:[EMAIL PROTECTED] Sent: 26 September 2008 23:53 To: General discussion for Windows Installer XML toolset. Subject: Re: [WiX-users] Insert error > I'm

Re: [WiX-users] Insert error

2008-09-26 Thread Richard
> I'm using DTF to insert a new row into an empty CustomAction table. I'm > using the following block of code : > > RunMSIQuery(txtMSI.Text, "INSERT INTO `CustomAction` (`Action`, `Type`, > `Source`, `Target`) VALUES ('VisionappSecurityGroup', 51, > 'SecurityGroup', 'v-[NtName]')" > > public stat

Re: [WiX-users] Insert error

2008-09-26 Thread Rob Mensching
You can only add Temporary rows in a CustomAction -Original Message- From: Powell, Simon [mailto:[EMAIL PROTECTED] Sent: Friday, September 26, 2008 06:37 To: wix-users@lists.sourceforge.net Subject: [WiX-users] FW: Insert error Hi, I'm using DTF to insert a new row into an empty CustomAc