Using Select option in Native SQL

[former_member671224]

Hi,

Can any one tell me, how to use select option value in native SQL.

ie.,

I want to use select option in where condition. Need to select all the records from table(non-SAP) where date in given range.

Please suggest.

Thanks,

Amal

[Former Member]

I think you'll have to find another way.

Rob

[Former Member]

it is not possible to use select options in open sql

[former_member671224]

There is no any option?

Thanks,

Amal

[Former Member]

Hi

No!

U need to find a way to convert a range of select-option to a range for Native SQL, probably it should be better doesn't use a select-option for the date but two parameters: one for date from and one for date to.

Max