How do you read data from word document through SQR
file interface
for financials u can refer student guide.pdf where complete information for financials is present.
I would say you to prepare Asset management, Account Payable, General Ledger, Variance.
How many scroll levels can be set in a page?
Level 0
Level 1
Level 2
Level 3
Total 4
There are four Scroll levels in a standard page.i.e.,0,1,2,3
How to create auto-generate for id? For example, the id for new transaction page automatic generated.
You can use 'NEXT' for auto generating the IDs. Otherwise you can write your own coding as follows.
SQLEXEC("get the max value from the table",&count)
&count=&count+1;
SQLEXEC("inserts the new count value to the database");
What is the difference between section commit and step commit
CoCommit: If we select commit from section after the completion of each step commit occur, else commit occur which respective step properties.
Section commit applies to a section as a whole and step commit, in each step. We can override the section commit value in Step level. Suppose there is no commit action mentioned in a section, but you can override in teh step and mention to commit after that step execution.
What is the differences in debugging and tracing
Debugging is step-by-step/line by line and you can see the values in variables while they are getting changed/populated by enabling the debugger option in AE.Tracing: In the login page you can set &am...
AE debug: Go to configuration manager of (App Designer). Then navigate thru Profile > Edit > Process Scheduler > Application Engine, check the Debug option. Open the AE program needs to d...
What is the difference between search record and addsearch record.
Search record controls the amount of data that can be requested and downloaded from the database server as well as the structure of the search dialogue box. It is also responsible for populating l...
Specify this record if you want a different search record specifically for add actions. For example, if you selected the auto-numbering option for employee IDs (EMPLID), don’t include EMPLID in the ...
Why we cant use views as a state record?
state records are used to store values that can be passed between actions in AE programmes. whereas views are not actual physical table. they are unable to hold values. that's why we can't use views as a state record.
State Records are used for storing values that we would like to share between actions and steps in an AE program, so they have to be tables.
BTW: Why do you need to use a view as a state record?
I have written peoplecode for sending emails. But I am getting the smtp send mail error. An error occurred during the smtp, could anyone please suggest this.
check your parameters. i have also faced such problem just because of wrong and initialise parameters.
SMTP Server is not configured for the environment.
Can we call one SQR program in another SQR program? How? In all platforms
We cannot call SQR program from another SQR program because each SQR has a main function. We cannot have two main functions.
It is coded in c and java
What is the full form of sqc and sqt in peopesoft?
SQC-Structured Query Compiler (Library file)
SQT-Structured Query Translation (Compiled version of SQR)
SQC is STRUCTURED QUERY COMMAND
What are the differences between move and let commands in SQR???
Move command is used for transferring a single value along with edit options. Where in case of Let option you cant use the edit option, rather you can use expressions. Hope this helps.
Hi
Move command used to move the values from loaction to other and to assign a values to variable or a literal LET command will be used.
What happens if you don't specify a search record for a component?
Fist thing, if the search record is not specified then the editor will not alow us to save.
Secondly, if the rquirement itself demands to skip the search record then, the best thing is to use a dummy search record called - INSTALLATION.
This would solve it.
Component will not be saved without a search reacord
What are explicit print and implicit print
In Explicit Print Command, you code the Print Command giving the coordinates where you want to print the data. However, in the implicit Print Command you can print the value directly from the se...
Here we have two types of print commands1) Implicit print: (a) here no need to give the print statement. (b) mainly useful for variables...2)explicit print: (a)we must give the...
How to perform line by line debugging in application engine?
Line by line Debugging option is possible, by enabling the Debugger option in the Configuration Manager. At the point from where you want to debug the code, set the break-point. From there by pressing F7 you can do line by line debugging.
Give an example to configure ci in peoplesoft
A component interface is a people tool to enable a PeopleSoft comonent for synchronous access from another application (PeopleCode, Java, C/C++ or XML) There are 5 different methods available in component interface. They are Save, Cancel, Find, Create, Get.
Why levels are used in on-break logic.How does they work.Which lebel gets highest priority EIther level 1 or level 99.
On-break: On-break can only be used on string and column variables. We cannot use on-break with sqr numeric variables. To perform this, we must first move its value to a string variable & then set on-...
On-break is the important Command in SQR used to Control the redundancy of data..here SQR have different options for on-break...
1)After
2)before
3)never
4)always
5)change
6)change/top page
Above options are used with Group Headings and Footings
What are the differences between move and let commands in SQR??
Move: To move the contents of one field to another field with optional editing
Let: To assign the values to the variable
the basic difference between move and let areMOVEthe move command can use the edit option and can easily have the masking move date1 date2 edit yyyy-mm-dd LETLet command is only used to assign values to the variablesLet var1=var2 or 5
by using -printer:PD command