c#: Deployment.WindowsInstaller.BadQuerySyntaxException: SQL query syntax invalid or unsupported

Multi tool use
Multi tool use


c#: Deployment.WindowsInstaller.BadQuerySyntaxException: SQL query syntax invalid or unsupported



My program is a simple one.



What I want to achieve in this particular method-



I am using Microsoft.Deployment.WindowsInstaller to read through MSI files and create MST.


Microsoft.Deployment.WindowsInstaller



It is failing at below parts of code:


count = (int)database.ExecuteScalar("SELECT COUNT(*) FROM Shortcut");
....
database.Execute("DELETE FROM Shortcut WHERE `Shortcut`.`Target` LIKE '%.chm'");
Console.WriteLine("chm deleted");



The error that I'm getting is:



Unhandled Exception: Microsoft.Deployment.WindowsInstaller.BadQuerySyntaxException: SQL query syntax invalid or unsupported.



Could someone help me with this?





@mjwills It gives same error. All other SQL statements are working fine. I'm having trouble with just these two. Instead of LIKE '%chm' if I give = '<FullName>' it works fine.
– Praveen
Jul 3 at 4:56




2 Answers
2



Windows Installer SQL isn't the same as full SQL - it's a subset, and some things don't work. For example, using Select Count(*) doesn't work in my tests, so may need to iterate through them. Also "like" may not be supported.



Online: As Phil states, the MSI SQL syntax is a sub-set of normal SQL. You can find information on the MSI SQL syntax online here.



Offline: You can also find the MSI SQL Syntax described in the msi.chm help file (Windows Installer SDK) which is installed with the Windows SDK or the WiX toolset (download).


MSI SQL Syntax


msi.chm


Windows SDK


WiX toolset


download



Just search for the help file on disk - or find it in the WiX installation folder if you have WiX installed. The latter is probably much faster and easier than searching the SDK folders.






By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Ti,YOO c ZIARIpZyMXDkh 3oB,QIy6JCW9p73cVPNvrLS YJ6qinEnX,3RVVyl,y31TDkS7TqdoMnl,pHpNrJ1p
-
oqqkJbzdes it8VO8B,ygeZpeZh5Dy Qwaw

Popular posts from this blog

PHP contact form sending but not receiving emails

PHP contact form sending but not receiving emails I have created a contact form using PHP to send the data. The form seems to send fine as there are no errors and success message appears, however I am not receving the emails into the designated inbox. I am using PHPMailer as I originally tried just using the php 'mail' command which I now understand is a bit hit and miss. I cannot see why I would not be receving the emails so I would be very grateful for any help that could be given. I'm quite new to PHP so please be patient with me :) <?php use PHPMailerPHPMailerPHPMailer; use PHPMailerPHPMailerException; $msg = ""; if (isset($_POST['submit'])) { require 'phpmailer/src/Exception.php'; require 'phpmailer/src/PHPMailer.php'; require 'phpmailer/src/SMTP.php'; function sendemail ($to, $from, $body) { $mail = new PHPMailer(true); $mail->setFrom($from); $mail->addAddress($to); $ma...
Read more

Do graphics cards have individual ID by which single devices can be distinguished?

Do graphics cards have individual ID by which single devices can be distinguished? I have several graphics cards of the same manufacturer and same model and I want to distinguish them not only by the pcie socket they reside in but by some individual value I can read from the hardware. Is there such value and if so what would it be called and how could I access it? Right now I'm using modern nvidia cards (10xx series) and nvidia inspector.but I'd prefer if there was any value that was also applicable to amd. I have programming and scripting knowledge. I am running Windows 10 1 Answer 1 This is a powershell example to pull information from video cards. The DeviceID is supposed to be unique but only if the manufacturer supports Windows Display Driver Model (WDDM). (I copied this directly from docs.microsoft.com) $strComputer = "." $colItems = get-wmiobject -class "Win32_VideoC...
Read more

Create weekly swift ios local notifications

Create weekly swift ios local notifications I can create daily notifications but not weekly ones using swift 3 ios 10 User Notifications framework. Daily works fine but when I add in the .weekday parameter it doesn't send me a notification. The code is: for i in 1 ... 7 { let center = UNUserNotificationCenter.current(); let content = UNMutableNotificationContent(); content.title = "Title"; content.body = "content"; content.sound = UNNotificationSound.default(); var dateComponents = DateComponents(); dateComponents.weekday = i; // hours is 00 to 11 in string format if (daynight == "am") { dateComponents.hour = Int(hours); } else { dateComponents.hour = Int(hours)! + 12; } // mins is 00 to 59 in string format dateCom...
Read more