That was my first thought too, but according to MSDN
(http://msdn.microsoft.com/en-us/library/aa372021(VS.85).aspx):
A {column-list} is a comma-delimited list of one or more table columns referred
to as {column} selected. Ambiguous columns may be further qualified as
{tablename.column}. An asterisk may be used as a column-list in a SELECT query
to represent all columns in the referenced tables.
Is that a bug in documentation?
-----Original Message-----
From: Blair [mailto:os...@live.com]
Sent: Friday, May 14, 2010 8:57 AM
To: 'General discussion for Windows Installer XML toolset.'
Subject: Re: [WiX-users] Accessing Custom Table
Windows Installer's SQL engine doesn't recognize "*" as a valid column-list.
You have to explicitly list each column in your query string.
-----Original Message-----
From: Thomas Spranger [mailto:m...@thomas-spranger.de]
Sent: Wednesday, May 05, 2010 1:41 AM
To: wix-users@lists.sourceforge.net
Subject: [WiX-users] Accessing Custom Table
Hi Guys,
I'm trying to access a custom table via a custom action. I found an article on
the Internet
(http://blogs.technet.com/alexshev/archive/2008/02/14/from-msi-to-wix-part-6
-customizing-installation-using-custom-tables.aspx) but I get the Message
<Msi API Error: OpenView,Sql Line 10, Column 11>
and don't know what to do with. So you see that my script don't like the
OpenView-Method. I have no other idea...
Greetings Thomas
PS: Here is the code of my customaction:
<CustomAction Id='LoadFeatureTable' Script='vbscript' >
<![CDATA[
Dim Database
Set Database = Session.Database
If Database Is Nothing Then
MsgBox "Error while
loading Database"
End If
Dim View
Set View = Database.OpenView("SELECT * FROM `CyberFeatures`")
'View.Execute
'Dim Record
'Set Record = View.Fetch
'If View Is Nothing Then
'MsgBox "Error while loading View"
'Set Database = Nothing
'EndIf
'Do Until Record Is Nothing
'MsgBox "ID: " & Record.StringData(1) & "\nSerial: " &
Record.StringData(2) & "\nName: " & Record.StringData(3)
'Set Record = View.Fetch
'Loop
]]>
</CustomAction>
----------------------------------------------------------------------------
--
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
------------------------------------------------------------------------------
_______________________________________________
WiX-users mailing list
WiX-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/wix-users
