topic Re: Reg select-options in Application Development and Automation Discussions

Reg select-options

Former Member — Fri, 29 Sep 2006 10:22:40 GMT

Hai all,

Under select-options i have declared 3 varibles

1.X1 is of char(30)

2.X2 is of char(4)

3.x3 is a date field.

now i have to get values from a db table where x1 begin with 'ARC5' and date in x3 entered on screen.

if x1 is entered on screen fetch those records otherwise dont fetch any records.

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 10:27:11 GMT

hi,

Do this way ..


 if not x1 is initial.

  Do something.

 endif.

Regards,

Santosh

Re: Reg select-options

former_member404244 — Fri, 29 Sep 2006 10:31:52 GMT

hi ganesh,

first select data basing on the select-options fileds and then do like this.

if x1[] is not initial.

write the seelct query here.

endif.

Regards,

Nagaraj

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 10:32:25 GMT

Under select-options i have declared 3 varibles

1.X1 is of char(30)

2.X2 is of char(4)

3.x3 is a date field.

now i have to get values from a db table where x1 begin with 'ARC5' and date in x3 entered on screen.

if x1 is entered on screen fetch those records otherwise dont fetch any records.

SELECT fields FROM dbtable

WHERE xf2 in X2 and xf3 in x3 and xf1 in x1.

Since you have defined it as select-options..if you leave it blank it means all records. Secondly for X2, on the screen you can enter the pattern ACR5* and it would fetch the records according to the selected pattern. For date it is similar to X1.

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 10:39:02 GMT

hi,


  If  x1 cp 'ARC5*'.
     select * from xyz into table it_xyz 
       where x1 = 'ARC5%' and
             x3 = x3.
  endif.

REgards,

Sailaja.

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 10:44:18 GMT

A small correction in the code above

If x1 cp 'ARC5*'.

select * from xyz into table it_xyz

where x1 <b>LIKE</b> 'ARC5%' and --> for pattern

x3 <b>IN</b> x3. -> select-options

endif.

Hope Sailaja wont mind it.

Kind Regards

Eswar

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 11:36:37 GMT

Hi,

start-of selection.

if not x1[] is initial.

select * from <db> where

f1 = 'ARC5'

and f2 in x3.

endif.

Regards

amole

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 14:11:35 GMT

Hi ganesh,

1. we need to do this in 2 steps.

(bcos getting data from table with beginning with ARC5 etc, is complicated)

a) select * from dbtable

into table itab.

where DateField In X3.

b) loop at itab.

if itab-X1(4) = 'ARC5' .

ELSE.

DELETE ITAB.

ENDIF.

ENDLOOP.

regards,

amit m.

Re: Reg select-options

Former Member — Fri, 29 Sep 2006 14:57:04 GMT

Hi Ganesh,

if X3 is a select option, use CODE A and if X3 is a parameter, use CODE B:

CODE A:

if not x1 is initial.

select x1

from <dbtable> into <internal table>

where x1 = 'ARC5%'

and x3 in x3.

endif.

CODE B:

if not x1 is initial.

select x1

from <dbtable> into <internal table>

where x1 = 'ARC5%'

and x3 = x3.

endif.

Regards,

Divya

Message was edited by: Divya Lingala