[wix-users] Parameters in SqlScript element

[Ven H]

Thanks a lot, Edwin. No, I haven't tried that. Will try and update. Thanks
a lot, once again.


Regards,
Venkatesh

On Tue, Apr 10, 2018 at 1:40 PM, Edwin Castro <egcastr at gmail.com> wrote:

> I don't think SqlScript supports parameters.
>
> Have you tried specifying SqlFileSpec and SqlLogFileSpec elements as
> children to SqlDatabase? Have you tried setting SqlFileSpec/@FileName and
> SqlLogFileSpec/@FileName to the values of the appropriate properties?
> Something like
>
> <SqlDatabase ...>
>     <SqlFileSpec ... FileName="[DATA_FILE_PATH]"/>
>     <SqlLogFileSpec ... FileName="[LOG_FILE_PATH]"/>
> </SqlDatabase>
>
> --
> Edwin G. Castro
>
>
> On Tue, Apr 10, 2018 at 12:30 AM, Ven H via wix-users <
> wix-users at lists.wixtoolset.org> wrote:
>
>> I have a .sql file which I am executing using SqlScript element in WiX.
>> There are some parameters inside the .sql file which need to be passed
>> during the execution of the script. Is it possible to pass parameters
>> through SqlScript element? If not, is there any other way to achieve this?
>>
>> Also, I have a SqlDatabase element. In this I have to make the path for
>> the
>> data and log files configurable so that I can let the user decide it at
>> run
>> time during MSI installation. Even if I capture the values from the UI,
>> how
>> can I pass it to the SqlDatabase element at run time. Please help.
>>
>> ____________________________________________________________________
>> WiX Toolset Users Mailing List provided by FireGiant
>> http://www.firegiant.com/
>>
>
>