topic Re: Insert line to database in Application Development and Automation Discussions

Insert line to database

Former Member — Wed, 24 Oct 2007 03:11:22 GMT

Hi all

i using a textedit control. i able to read line by line in texteditcontrol. Now i gt problem in inserting each line to database. Any code for this situation.

below is my code to read each line.

CALL METHOD g_editor->set_text_as_r3table

EXPORTING table = g_mytable.

Thks

Re: Insert line to database

Former Member — Wed, 24 Oct 2007 03:15:04 GMT

Hi,

Use the INSERT statement to insert the values to the database

LOOP AT g_mytable.

Move the values to the work area..of the structure of database table.

INSERT ZTABLE FROM WA.

ENDLOOP.

Thanks

naren

Re: Insert line to database

Former Member — Wed, 24 Oct 2007 03:18:36 GMT

However my g_mytable declaration in in this format

CONSTANTS: line_length TYPE i VALUE 256.

g_mytable(line_length) TYPE c OCCURS 0

how can i resolve it

Re: Insert line to database

Former Member — Wed, 24 Oct 2007 03:20:36 GMT

Hi,

Not able to understand your requirement..Please explain in detail..

Thanks

Naren