Hello,
I am new to PeopleSoft dev.
I am have a test screen i am using to build this with a simple button. When I click the button i have the following code firing:
Local NDC_EX_CONUS:NDC_EX_CONUS &teeter;
Local number &steeter;
&teeter = &aConusData [2];
WinMessage(&steeter);
SQLExec(&teeter.WriteEXLocation(3));
WinMessage("ga ga : " | &steeter);
WinMessage("Length of array of conus extracts: " | &aConusData.Len);
The error I get is happening at the SQLExec. Here is what the writeexlocation method code is:
method WriteEXLocation
/+ &num3 as Number +/
/+ Returns String +/
Local string &sSQL;
&sSQL = "Insert into PS_EX_LOC_TBL_TMP (SETID, TXN_LOCATION, EFFDT, EFF_STATUS, TXN_LOCATION_GRP, DESCR, DESCRSHORT, COUNTRY, STATE, SYNCID, SYNCDTTM) VALUES ('blaha', '00001', '2010-04-02', 'A', '', 'MAY(MPCG)', 'MAY', 'USA', 'CA', '', '')";
REM SQLExec("Insert into PS_EX_LOC_TBL_TMP VALUES ('HIED1', '00001', '2010-04-22', 'A', '', 'MAYVILLE (MPCG)', 'MAYVILLE', :1, 'ND', '', '')", "CNS");
Return &sSQL;
end-method;
Here is the error:
A PeopleCode program tried to issue the indicated message while an SQL cursor is open. The message is invalid because it requires user input.
Review the PeopleCode and either move the message to a place where it will be issued during user "think-time", or change the "style" so no choice is required.
Any idea why i am getting this. I am not asking for user input so I don't know what this error is referring?
Any help you could provide would be great. Thanks for the help.
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Hi
Remove the Winmessages written in the code and try, this should solve the problem.
Rekha
That was exactly the problem. thank you for the help. Can you explain why this is the case as it worked fine with the winmessages there until I created that method in my app class.
without the winmessages how would you debug this sort of stuff? We don't have the debugging feature enabled so I can't use that.
Post new comment