topic Re: insert statement problem in Application Development and Automation Discussions

insert statement problem

Former Member — Wed, 02 Jan 2008 11:12:01 GMT

hi experts,

insert zqm_tb_is1786n FROM final2 ACCEPTING DUPLICATE KEYS.

system is throwing error for this message as

'.' has to be inserted after final2

what is the reason .

i am inserting values from final2 internal table to my ztable .

regards,

mani

Former Member — Wed, 02 Jan 2008 11:17:19 GMT

good

go through this link,this will give you clear idea abou the insert statement,

thanks

mrutyun^

Former Member — Wed, 02 Jan 2008 11:18:48 GMT

INSERT dbtab FROM TABLE itab. oder

INSERT (dbtabname) FROM TABLE itab.

Extras:

1. ... CLIENT SPECIFIED

2. ... ACCEPTING DUPLICATE KEYS

3. ... CONNECTION con

Hi change your code as below and check

insert zqm_tb_is1786n FROM TABLE final2 ACCEPTING DUPLICATE KEYS.

Former Member — Wed, 02 Jan 2008 11:20:31 GMT

Hi,

the exact form of statement required for u is

insert (u r DB table name) FROM TABLE <internal table> ACCEPTING DUPLICATE KEYS.

Former Member — Wed, 02 Jan 2008 11:26:46 GMT

hi,

i have an internal table final2 with 3 line items like

delivno item material

800001 10 500000

800001 20 500001

800001 30 500002

i am using the code.

loop at final2.

insert zqm_tb_is1786n FROM table final2 ACCEPTING DUPLICATE keys.

endloop.

but only the first line item is inserted into my table .what may be the reason?