fetch data from external file

Discussions about CSEntry
Post Reply
Shahmeer
Posts: 3
Joined: July 9th, 2019, 2:42 am

fetch data from external file

Post by Shahmeer » July 9th, 2019, 3:03 am

dear all CSPro community,

I am new to cspro i need your help.
I want to fill all fields of PPRPIMPACT from LFPPRP. if ID fields matched.
I also need your help in creating dynamic valuesets.
program files are attache please help.
Attachments
PPRPIMACT.zip
(34.97 KiB) Downloaded 14 times

aaronw
Posts: 190
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: fetch data from external file

Post by aaronw » July 9th, 2019, 5:25 pm

Once the id items have been entered for PPRPIMPACT, you can call loadcase to see if the case exists in LFPPRP. If it does the values will be in memory and you can do the assignments.
if loadcase(LFPPRP_DICT, DISTRICT, TALUKA, UC, TRAINEE) then
   
DISTRICT_NAME = LFDISTRICTNAME;
    // etc
endif;
For dynamic value sets take a look at the workshop materials in session 5.

Shahmeer
Posts: 3
Joined: July 9th, 2019, 2:42 am

Re: fetch data from external file

Post by Shahmeer » July 10th, 2019, 7:52 am

Thank you very much for helping me "aaronw"
The maketext("%V%V%V%V", ...) is giving invalid argument error. rest is fine. once again thanks.

aaronw
Posts: 190
Joined: June 9th, 2016, 9:38 am
Location: Washington, DC

Re: fetch data from external file

Post by aaronw » July 10th, 2019, 4:09 pm

No problem, I've corrected the errors in the above logic.

Post Reply