Search results

Anyone know what are called data buffers? How many types of data buffers are used in progress? What are they?

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!

Qn 25: How can more values be returned from one particular function? Ans Convert the function to procedure?

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 21: What are the ways to pass a temp-table as a parameter? Ans: Use TABLE FOR?

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 12: Describe the ways to pass parameters to an include file: Ans: Arguments, Pre-processors

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...