When I try to use the search to search for topics related to specific keywords, I get the above error. Anyone know how to go about searching for topics?
Qn 30: Write a procedure (p1.p) that contains a function internalFunction() and a procedure internalProcedure (both returning a string). Write another (p2.p) procedure to call both the internalFunction() and the internalProcedure from the first procedure using super-procedures mechanism.
Qn 27 and 28 are skipped.
Qn 29: What messages are shown after running the following code (in both cases!) ?
a.
PROCEDURE p1:
MESSAGE 1 AVAILABLE(customer).
END PROCEDURE.
PROCEDURE p2:
DEFINE BUFFER customer FOR customer.
MESSAGE 2 AVAILABLE(customer).
END procedure.
FIND FIRST customer...
Qn 26: What is the difference between searching and filtering when using a database table?
Ans: Search – searches for the records in the table – usually returns logical answer.
Filter – filters out and returns the only required records – physically brings the data
Not confident on the above answer!
I will ignore Qn 22 as it is another include file. Qn 23 is simple.
Qns 24: We have the code below. What happens when the <condition> becomes true? What block is left and how can we force to leave the other block?
For EACH table1:
For EACH table2:
/*Do something…*/
IF condition THEN
LEAVE...
Qn 20: What happens when you use NO-ERROR clause in a (internal or external) procedure call? How we can treat the error in both cases (with and without the NO-ERROR)?
Ans: NO-ERROR suppresses any error on the RUN statement itself.
The messages can be captured using NUM-MESSAGES or GET-MESSAGE...
Qn 19: Name the main difference between FIND statement and CAN-FIND() function. What CAN-FIND() returns?
Ans: FIND fetches the record from the database and makes it physically available.
CAN-FIND() just returns a logical yes/no to say whether a record is available in the database
Qn 18: What is the default locking level for reading records in Progress? Give some reasons why this should be used or not!
Ans: Default locking when no explicit lock is given is SHARE-LOCK.
When another user reads the same record and starts updating, the record gets locked for the second user...
Qn 17. What is the difference between ADD-FIELDS-FROM () and ADD-LIKE-FIELD() methods of a dynamic temp-table? Name another method to add fields to a dynamic temp-table!
Ans: ADD-FIELDS-FROM adds all the fields from the mentioned table to the temp-table.
ADD-LIKE-FIELD() adds only the mentioned...
Qn 15: Is the following code correct? Explain! Assume that Sports2000 database is connected!
DEFINE VARIABLE order-rec AS ROWID.
DEFINE VARIABLE answer AS LOGICAL.
REPEAT:
FIND NEXT order NO-LOCK.
DISPLAY order WITH 2 COLUMNS 1 DOWN.
MESSAGE "Do you want to update this...
Qn 14: Check the code below and mention if a progress transaction is started or not in each case!
answer (Y/N)
FOR EACH table:
DISPLAY table.
END.
No
FOR EACH table:
UPDATE table.
END
Yes
FIND FIRST table.
REPEAT ON ENDKEY UNDO, LEAVE:
ASSIGN table.field = aFunction().
FIND NEXT table...
Qn 13: What is the difference between “RUN procname.p” and “RUN procname.p PERSISTENT SET handle” statements?
Ans: 1st one is a call to an external procedure and 2nd one makes procname.p as a persistent procedure for the duration of the called procedure.
Qn 1. Enumerate the layers of a 3-tier application:
Ans: Presentation/Application Layer, Business Logic Layer and Data Layer
Qn 2. What are (some of) the PROPATH's characteristics (check the appropriate entries)?
1. it is an OS environment variable -yes
2. .r files are automatically searched...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.