Forum Discussion

Felms's avatar
Felms
Occasional Contributor
16 years ago

Re: passing in sql via command line

Hi,
I have one tests that will retrieve different data in a database depending on the sqlplus query that I setup in my datasource.
Is there a way to pass in sql in the command line to override the sql I have in my datasource? I'm using testrunner.bat to execute these tests on the command line.

Frank

1 Reply

  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    16 years ago
    Hi,

    yes.. you can use the -P switch to pass project property values; set up a project property containing the default SQL and use that in your query (with property-expansion), then when running from the command-line override the sql with -Pname=value argument(s)

    regards,

    /ole
    eviware.com