Changing manually created SQL-Statements (add command)

[Former Member]

Hi everybody,

I generate my reports using SQL-Statements in the database assistant > add command.

For test purposes I only use a test database which does not equal the production database.

Therefore sometimes I have to use larger periods to really get some values for the report (e.g. 6 months instead of last month only).

Can I change my "add command" later on for the right period?

Thanks for your help.

Rgds

Eberhard

[abhilash_kumar · Accepted solution]

Hi Eberhard,

Yes you can.

You'd go to the Database Expert > Right-click the command object and click 'Edit'.

Edit and query and then click OK.

-Abhilash

[former_member205840]

Hi Eberhard,

Yes, you can.  Before that, instead of hard coding begin and end dates in your command (SQL), there is a button right had top to create a parameters.  Try to create two parameters (it depends on how you filter data) one for start date and other for end date and insert these parameters in your SQL WHERE clause.

So, each time when you refresh, it will take your input for start date & end date.  Even if you move this report to other environment, you don't need to change SQL.

Thanks,

Sastry

[Former Member]

Hi,

Yes you can change the command later on when you move to a different env provided the target tables resides on that environment.

Regards

Niraj