parameters in wd

[Former Member]

Dear all,

I am getting an empty value in a table If i dont give any values in the search parameters of carrid and connid.

So how to get a values in a table if i do not give any values in the search parameter. ??

Thanks and regards.

[Former Member · Accepted solution]

you can change your select query by using

if condition

if both carrid and connid are empty

select * from table into internal_table.

else.

select * from table into internal_table where ( conditiion).

[Former Member]

hi vijay

try this :

if carrid is initial or connid is initial.

select * from <table name> into <internal table name>

else.

select * from <table name> into <internal table name> where carrid = carrid and connid = connid,

endif

regards

vaibhav

[Former Member]

Well instead of using PARAMETERS you may want to use SELECT-OPTIONS with option I_NO_EXTENSION and I_NO_INTERVALS. Then in your SQL Query just make use of IN statement.

Hope it helps. Cheers!