Page 1 of 1

fetch data from external file

Posted: July 9th, 2019, 3:03 am
by Shahmeer
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.

Re: fetch data from external file

Posted: July 9th, 2019, 5:25 pm
by aaronw
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.

Re: fetch data from external file

Posted: July 10th, 2019, 7:52 am
by Shahmeer
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.

Re: fetch data from external file

Posted: July 10th, 2019, 4:09 pm
by aaronw
No problem, I've corrected the errors in the above logic.