topic Re: codition in Application Development and Automation Discussions

codition

Former Member — Sat, 14 Jun 2008 06:21:47 GMT

how to create using a table using condition like if we have gender deatils to create then we have to give here m,f .so in this how to create table?

Re: codition

Former Member — Sat, 14 Jun 2008 11:12:01 GMT

hi check this.....example for using the tables

PARAMETERS: p_carr TYPE sflight-carrid,

p_conn TYPE sflight-connid.

DATA sflight_tab TYPE STANDARD TABLE OF sflight.

PERFORM select_sflight TABLES sflight_tab

USING p_carr p_conn.

FORM select_sflight TABLES flight_tab LIKE sflight_tab

USING f_carr TYPE sflight-carrid

f_conn TYPE sflight-connid.

SELECT *

FROM sflight

INTO TABLE flight_tab

WHERE carrid = f_carr AND

connid = f_conn.

ENDFORM.

Re: codition

former_member156446 — Sat, 14 Jun 2008 21:40:07 GMT

that field need to be a primary key.. so when user try to enter some thing new.. it will raise an error.. he will just select it from the F4 help...

if you donnot want to make it primary key.. in table maintenance generator you have to give the validations.. saying if not male or female raise error..