Query not executing using inno setup

Asked Mar 10 '15 at 13:08

Active Mar 10 '15 at 13:08

Viewed 76 times

I am executing a query in inno setup using sqlcmd. The purpose of the query is creating database. I have tried the query so far in sqlcmd which take a keyword 'GO' after after entering the query. The question is how to embed the keyword 'GO' after the query so it executes.

the pascal script which i have used is:

    [Code]
    Begin
         exec('SqlCmd.exe', ' -E -S Haider-PC ' + ExpandConstant('-Q "CREATE DATABASE Test"'), '', SW_SHOW, ewWaitUntilTerminated,ResultCode);      
    End

asked Mar 10 '15 at 13:08

Haider Khattak

1

Why do you want to *embed* `GO` ? The [`help`](https://msdn.microsoft.com/en-us/library/ms162773.aspx) explicitly warns about not using it (see `-Q`, or `-q` parameter descriptions. – TLama Mar 10 '15 at 13:12
@TLama...i tried to run the setup a couple of times but it is'nt giving any result – Haider Khattak Mar 10 '15 at 13:13
The database isnt creating.. – Haider Khattak Mar 10 '15 at 13:14
1

Forget about setup for now. First make it work in command prompt. Then move it to setup. – TLama Mar 10 '15 at 13:15
@TLama... what ever command i pass in sqlcmd it need 'GO' after pressing enter to execute the query then it works – Haider Khattak Mar 10 '15 at 13:19

Query not executing using inno setup

0 Answers0