Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Using Select option in Native SQL

former_member671224
Participant

‎10-07-2008 3:12 PM

0 Kudos

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

4 REPLIES 4

Former Member

‎10-07-2008 3:15 PM

0 Kudos

I think you'll have to find another way.

Rob

Former Member

‎10-07-2008 3:22 PM

0 Kudos

it is not possible to use select options in open sql

former_member671224
Participant
In response to Former Member

‎10-07-2008 3:27 PM

0 Kudos

There is no any option?

Thanks,

Amal

Former Member
In response to Former Member

‎10-07-2008 3:39 PM

0 Kudos

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