Hi all,
My requirement is,
1. in a page PROCESS NAME is prompt table. if we select any one procee name.
2. insert pushbutton( when we click on it)
3.insert grid with 3 fields like OPRID,RUNCONTROL_ID, and one Checkbox.

Explanation is when we click on pushbutton based on processname those related data like oprid,runcontrol id values will populate into grid.

Now Q is prompt table is VW record
can i take WRK with 3 fields or 2 fields like oprid, run id.
what code i write in pushbutton.
i am new from peoplesoft..

please help me any one knows..
Regards
Guest

Hello,

I was able to apply the code delivered in FILE_ATTACH_WRK to send an attachment to our server, and also to retrieve (view) the file. But something is happening to the files when I return them from the server to view them. For example, I saved a text file, but when I pull the file back to view it appears that all the carriage returns have been removed. A file saved like this....

-- Script : delete_bad_referral.sql
--
-- 01/10/2011 rjm
--
-- Return failure code when program does not complete successfully
whenever sqlerror exit failure;
whenever oserror exit failure;

Can anyone tell me what's wrong with this function please?

/*Function to return a date a specified number business days from an input date */
Function getBusinessDays(&inputDate, &numDays) Returns date
/* Date variable to hold future date to be returned */
Local date &futureDate;

/* SQL Statement to return future date */

Can someone please explain me the difference between the use of "..value" and ".". At many places I have noticed we assign/fetch the value to/from a record field using .VALUE and sometimes without that!

What is the actual concept behind this?

Hi,

I am working on a page having grid on level2. In grid,i am fetching the data for some fields from a table which is differ then the table in my project. but the data is updating with the time .i.e. it gives different number of rows from the database. But in my grid,
When i am clicking on (+) button to populate the grid again, it is showing me only the previous rows,not the new ones from the database and i want all the updated rows (number of rows may increase or decrease in database ).

Can anyone suggest on this plzz,

Thanks in advance.

There are two ways to hide a column on a grid. 1) Either use PeopleCd or
2) “Check” the invisible check box on the Field Use Tab, which is on Edit Box Properties for the fields contained on the grid.
Here is the question: Is one way better than another?

Thank you for any suggestions

On clicking VIEW ALL / FIRST / LAST / NEXT / PREVIOUS links in a scroll area or a grid, a javascript function with parameters of hviewall / htop / hend / hdown / hup is called respectively.
(reference :- http://xtrahot.chili-mango.net/2007/05/a-look-at-submitscriptname/)

So can we catch hold when any of this button is clicked on the grid? Do we have any event or any other thing associated with this?

I'm using PeopleSoft technology. I have a grid at level 1 and an employee role field. Now, while selecting values, I have to provide a particular role (project leader) to only one employee (resource). But, I can provide the team member role to multiple employees. The 2 roles, project leader and team member are contained in translates for the employee role field. So, I want that while values are being entered in a grid, and one employee gets allocated the project leader role, the user should not be able to select the project leader role for any other employee in the active grid.

I'm making a Project Management System. In the project, when the Project Manager wants to select a project leader and team members , he gets the name of the employees in the look-up list which is fetched from the employee master table. Now, when he selects his resource list , if he selects a particular resource as a project leader in the 1st row of the grid , he should not be able to select any other resource as project leader.
Since, there can be only 1 project leader for a particular project.

However, its okay if he selects multiple team members ..

I want to set a particular field (employee id) as display only (or gray) , basically unedittable after it's selected in a Grid .. I applied the code on the Field Edit event of that field and I'm able to set the particular field (employee id) in the 1st row as display only (when I select it from the look-up list). However, as I add the next row in the grid and select the particular field (employee id) from my look-up list, it no longer becomes display only.