Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

copying data from basic list(output screen) to a pc file & then uploading

Former Member

‎2010 Jan 06 12:04 PM

0 Likes
349

Hi Experts,

i have created one zemployee table having fields empid,empfname,emplname,empdesignation,empsalary.i have one selection screen having parameters empid & multiplied_by.i have to multiply the particular employee's salary with the number in the multiplied_by parameter & update the database table with the new salary.this much i have done correctly.my doubt is ,after this i have to upload empid, old_salary & new_salary to the application server.for using GUI_UPLOAD & OPEN DATASET statement first we have to copy these datas to a pc file,rt?how this can be done?

thanks in advance.

Hi Experts,

i have created one zemployee table having fields empid,empfname,emplname,empdesignation,empsalary.i have one selection screen having parameters empid & multiplied_by.i have to multiply the particular employee's salary with the number in the multiplied_by parameter & update the database table with the new salary.this much i have done correctly.my doubt is ,after this i have to upload empid, old_salary & new_salary to the application server.for using GUI_UPLOAD & OPEN DATASET statement first we have to copy these datas to a pc file,rt?how this can be done?

thanks in advance.

Reply
1 REPLY 1
Read only

Former Member

‎2010 Jan 06 12:12 PM

0 Likes
292

Hi,

Build an internal table(itab1) with empid, old_sal and new_sal.

You need to take the entry from the table with key empid and mutliple by the value given on selection screen. Append a record in the itab1. Then Modify the table with this record, if successfully then Open a file in the application server, wirite the data to that file and close the file. After this call the GUI_DOWNLOAD to put the same file on pc.

Regards,

Aditya