Got it...
PMSIHANDLE hParamRec = MsiCreateRecord(1);
WcaSetRecordString(hParamRec, 1, pwzData);
hr = WcaExecuteView(hViewServer, hParamRec);
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Adam Langley
Sent: Monday, 2 July 2007 6:05 p.m.
To: [email protected]
Subject: Re: [WiX-devs] using WcaExecuteView to join tables
Or, I suppose a better question is, How do I pass arguments of my own to
WcaExecuteView?
I would essentially like to pass 2 arguments to ExecuteView for substitution
with multiple '?' in the query, but my arguments are not in any
PMSIHANDLE... theyre just LPWSTR strings...
From: Bob Arnson [mailto:[EMAIL PROTECTED]
Sent: Monday, 2 July 2007 5:43 p.m.
To: Adam Langley
Cc: [email protected]
Subject: Re: [WiX-devs] using WcaExecuteView to join tables
Adam Langley wrote:
(sorry for sending these emails directly to your address all the time, I
just click 'reply', as Im used to mailing lists having the posting address
as the reply address (on behalf of...))
It's one of those things guaranteed to annoy 50% of the population.<g>
line 30 has:
LPCWSTR vcsSqlBinaryScriptQuery = L"SELECT `Data` FROM `Binary` WHERE
`Name`=?";
Then line 233 appears to open the Binary table view and retrieve a row,
using a row from the SQLScript table to populate the `Name` of the binary...
I cant see anywhere that the '?' is replaced with a the name of the
SQLScript Binary entry, so Im assuming this is happening automatically...
The WcaExecuteView call passes in the same hRec that it just fetched from
the SqlScript table. The first field in vcsSqlScriptQuery is ScriptBinary_.
There's only one ? parameter in vcsSqlBinaryScriptQuery so that's the field
value used in vcsSqlScriptQuery.
No magic, just a lack of comments.<g>
--
sig://boB
http://joyofsetup.com/
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
WiX-devs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/wix-devs
