topic Re: Using Select option in Native SQL in Application Development and Automation Discussions

Using Select option in Native SQL

former_member671224 — Tue, 07 Oct 2008 14:12:49 GMT

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

Re: Using Select option in Native SQL

Former Member — Tue, 07 Oct 2008 14:15:45 GMT

I think you'll have to find another way.

Rob

Re: Using Select option in Native SQL

Former Member — Tue, 07 Oct 2008 14:22:03 GMT

it is not possible to use select options in open sql

Re: Using Select option in Native SQL

former_member671224 — Tue, 07 Oct 2008 14:27:01 GMT

There is no any option?

Thanks,

Amal

Re: Using Select option in Native SQL

Former Member — Tue, 07 Oct 2008 14:39:22 GMT

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