When I try to run a custom developed SQR program, which has a bar chart, the error ”Unsupported Grafcap device –SQR 6458” was reported by the SQR engine.. Even when I tried with bar100.sqr program, which is a delivered SQR, the same error exists. Later I found the solution. There are three things to be considered while running any program with bar/pie/histogram etc.
c).SQR File Path
The code was provided by a guest by the name of Nate. I wanted to post the code as a blog entry to give it more visibility. The original forum question is http://compshack.com/forum/peoplesoft/peoplesoft-technical/sending-meeti...
I haven't used/tested the code, so please provide your feedback in the comments section below if you have.
I had the need to count an occurrence of a specific character in a string and after tossing some ideas back and forth between a couple of my colleges, we came up with the below two SQLs. You pass a string and identify the character you are looking to count its occurrence. In both SQLs below, I'm trying to count how many times does ">>" exists in string "This is>>a string>>to look into>>". The answer of course is 3 times.
SQL Option 1:
Following is the query that can be useful to find out all records under a specified component. All it requires is the component name, and type of record you want to check For example pass value as "0" to retrieve only record type as 'Table' under specified component
Here comes a sql beautifier web site for the readers who don’t know about this.
We can format the sql in a second by using this. Give a try and will see the difference in sql. Useful to understand the sql in easier way.
Many of you have might see an Error - Not able to update own data on PS delivered components
"You are not allowed to upadte your own data
You attempted to save a record containing an EMPLID field whose value matched the value defined in your operator profile.Contact other authorized user to update your data or contact your system adm."
Here is a quick way to overide that
Open the RowInit PeopleCode on the EMPLID field
|Peoplesoft Web PIA installation||PeopleSoft Technical||03/15/2017 - 2:20am|
|Populate Multiple Grids on a same Page with diff output based on conditions.||PeopleSoft Technical||03/04/2017 - 1:35pm|
|Updating a row using Peoplecode - Component Interface.||PeopleSoft Technical||02/21/2017 - 11:26pm|
|To load CSV file data into staging table without using file layout||PeopleSoft Technical||01/15/2017 - 8:31am|