UNION SQL Statement in VBScript

Question

I wrote a little script to get info out if MSI files. It works fine for simple SELECT statements. However when I use the following one it doesn't

SELECT Dialog_, Control, Text FROM Control 
UNION SELECT 'UIText',Key,Text from UIText

I get the error msg

Microsoft VBScript runtime error 1A8: Object required

I open the Database like this

Wscript.CreateObject("WindowsInstaller.Installer") 

Is the UNION statement not supported?

Answer 1

UNION isn't mentioned in the SQL Syntax supported by the Windows Installer, so it's probably not supported.