topic problem in select-options in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121410#M444668 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am facing a problem in select-options. In the select statement</P><P>Select field1</P><P> field2</P><P> .</P><P> .</P><P>Where fieldname(in database table) IN field1.</P><P>Where field1 is date(dats format(yyyymmdd))</P><P>-When values are entered in select-option(field1), even though the values entered in selection-screen are there in database table it is not </P><P>Fetching any records. Please help me.</P><P>-I defined field1 as : field type databasetablename-fieldname.</P><P>POINTS WILL BE REWARDED.</P><P>Regards,</P><P>Venkata</P></BODY></HTML> Fri, 06 Apr 2007 05:30:38 GMT Former Member 2007-04-06T05:30:38Z problem in select-options https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121410#M444668 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I am facing a problem in select-options. In the select statement</P><P>Select field1</P><P> field2</P><P> .</P><P> .</P><P>Where fieldname(in database table) IN field1.</P><P>Where field1 is date(dats format(yyyymmdd))</P><P>-When values are entered in select-option(field1), even though the values entered in selection-screen are there in database table it is not </P><P>Fetching any records. Please help me.</P><P>-I defined field1 as : field type databasetablename-fieldname.</P><P>POINTS WILL BE REWARDED.</P><P>Regards,</P><P>Venkata</P></BODY></HTML> Fri, 06 Apr 2007 05:30:38 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121410#M444668 Former Member 2007-04-06T05:30:38Z Re: problem in select-options https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121411#M444669 <HTML><HEAD></HEAD><BODY><P>Pls could u send ur selection-screen definition and select statement..</P></BODY></HTML> Fri, 06 Apr 2007 05:34:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121411#M444669 Former Member 2007-04-06T05:34:40Z Re: problem in select-options https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121412#M444670 <HTML><HEAD></HEAD><BODY><P>Pls write the code here.</P><P></P><P>rgds</P><P>Nishant</P></BODY></HTML> Fri, 06 Apr 2007 05:35:07 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121412#M444670 Former Member 2007-04-06T05:35:07Z Re: problem in select-options https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121413#M444671 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please provide your actual select statement and the data definition of the field you are talking about. Also pleaes clarify where are you getting the date to use in where condition. Then only we can help. </P><P></P><P>Regards,</P><P>Rs</P></BODY></HTML> Fri, 06 Apr 2007 05:35:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121413#M444671 Former Member 2007-04-06T05:35:12Z Re: problem in select-options https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121414#M444672 <HTML><HEAD></HEAD><BODY><P>i got the answer, i am closing this</P></BODY></HTML> Fri, 06 Apr 2007 06:53:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/problem-in-select-options/m-p/2121414#M444672 Former Member 2007-04-06T06:53:33Z