topic Re: form routine in Application Development and Automation Discussions

form routine

Former Member — Mon, 28 Aug 2006 05:53:58 GMT

Hi Guys,

FORM vehicle_tab_fill USING p_line LIKE line

CHANGING p_initvehicle LIKE initvehicle.

I have got a form, with the help of using and changing parameters. I need to write a query where in the data from the internal table should be inserted into database table and if any changes done to the database element it should modify it and also update the table in the database. with out re inserting the record again.

Is this query correct, if not please correct it and respond to it immediately.

SELECT SINGLE * FROM zvehicle INTO initvehicle

WHERE vin = zzvin.

IF bukrs = '4010'.

INSERT lines of initvehicle into p_initvehicle

where market = 'mlemarket'.

else

insert lines of p_vehicle into table zvehicle

where market = 'nscmarket'.

ENDIF.

UPDATE table zvehicle.

Awaiting to hear from you on it, reply as soon as possible.

cheers,

CHK

Re: form routine

Former Member — Mon, 28 Aug 2006 05:58:18 GMT

use modify inplace of update and insert. modify works for both update and insert.

Re: form routine

Former Member — Mon, 28 Aug 2006 06:05:57 GMT

Hi,

Where do u have the select query, inside the form routine or else you do it prior to that????

If you want to ensure that changes are recorded in the DB Instead of update use modify since it either inserts or changes.

Reward if helpful.

Regards

Re: form routine

Former Member — Mon, 28 Aug 2006 06:22:32 GMT

I need to insert it in the form routine. But i am unable to raed the contents from internal table to database. please check with my sql query will then happen correctly.

Re: form routine

Former Member — Mon, 28 Aug 2006 06:28:20 GMT

FORM vehicle_tab_fill USING p_line LIKE line

CHANGING p_initvehicle LIKE initvehicle.

user this:

FORM vehicle_tab_fill TABLES p_initvehicle LIKE initvehicle USING p_line LIKE line

Re: form routine

Former Member — Mon, 28 Aug 2006 06:30:37 GMT

user this:

FORM vehicle_tab_fill TABLES p_initvehicle LIKE STRUCTURE initvehicle USING p_line LIKE line

u will get the values and use the MODIFY statemnet..

may be this will help u

Re: form routine

Former Member — Wed, 30 Aug 2006 04:39:38 GMT

Hi,

Modify your query as follows :

SELECT SINGLE * FROM zvehicle INTO initvehicle

WHERE vin = zzvin.

append lines of initvehicle into p_initvehicle.

***here i`ve moved all the values from itab1 to itab2.

***Now read itab1 for bukrs condition and modify value ***of the market name.Now by doing this, you`ll have all

***neessary values in table p_initvehicle.

***Always check for the subrc value and then modify the ***database table, since rather than inserting or ***updating, when you modify existing values are changed

***else new values are inserted.

Reward if helpful.

Regards

Re: form routine

Former Member — Fri, 19 Jan 2007 08:05:03 GMT

Thank you, for your valuable suggestion.

Regards,

karthik