Updating Data Base table
Hi Experts ,
Presently I am having a requirement, to upload two dates fields in the ztable.
The input will be given in the form of xls.
I will be converting this to tex tab delimited file.
I have written an upload program .Where I have used the function moduel UPLOAD.
Once I uplaod the fields from upload file.This upload file contains two dates which has to be updated and other 3 three fields are key fields.
I need to check in the database for where the entries in the table are existing , if they are existing then I need update the particar with the dates.
This logic is also coded by me.
But the problem I am facing is that
I have used Modify statement, which is leading to removal of all fields entries for those records and just updating the same 5 fields which we are uplaoding.
Can any one suggest me the logic for this.
Just to update to two date fields with other fields being unaltered for a particular record.
Thanks in Advance,