Explore topic-wise InterviewSolutions in .

Buffer-COPY is ONE STATEMENT. This is used to bulk copy of a source RECORD to a target record by copying each source field to the target field of the same NAME.

Buffer-Copy is one statement. This is used to bulk copy of a source record to a target record by copying each source field to the target field of the same name.

1. It is USED to find out the TIME taking for execution of a PARTICULAR block
2. It RETURNS milliseconds.

The Delimiter is a character that is USED to SEPARATE the field values. The DEFAULT delimiter is space.

The Delimiter is a character that is used to separate the field values. The default delimiter is space.

When one procedure is accessing a table in EXCLUSIVE LOCK mode at the same time some other procedure TRY to access the same table it will not wait till the table is released if the no-wait option is used.

When one procedure is accessing a table in exclusive lock mode at the same time some other procedure try to access the same table it will not wait till the table is released if the no-wait option is used.

No, we can’t CREATE a word-index for an ARRAY FIELD.

No, we can’t create a word-index for an array field.

1. Web-speed 3.0 is a software, which is USED to DEVELOP web-based applications.
2. Web client is a software where client/Server applications will be accessed USING BROWSER like NETSCAPE or Internet Explorer.

<STRONG>WEAK SCOPE .

EG :- for each LOOP

Strong scope

eg :- Do for loop

Weak scope .

eg :- for each loop

Strong scope

eg :- Do for loop

To IDENTIFY the SCOPE of the RECORD.

To identify the scope of the record.

COMPILE &LT;external-procedure&GT;SAVE XREF <XREF-filename>

Compile <external-procedure>save XREF <XREF-filename>

XREF is USED to FIND out the INDEX being used in a FILE

XREF is used to find out the index being used in a file

No-error STATEMENT which is USED to SUPPRESS the PROGRESS ERRORS.

No-error statement which is used to suppress the progress errors.

For-first:

1. Using field option for specify the field name for modification
2. Using multiple index
3. Using WORD index field

Find-first:

1. In find first not SUPPORT the above three statements
2. In find first we use no-error and AVAILABLE option

For-first:

Find-first:

FIND:

In find statements if there are any non-primary key records which has DUPLICATION will PROVIDE AMBIGUOUS error

Find-first:

In find-first statements the ambiguous error will be overcome because which is return the first record from the buffer

Find:

In find statements if there are any non-primary key records which has duplication will provide ambiguous error

Find-first:

In find-first statements the ambiguous error will be overcome because which is return the first record from the buffer

1. For-first and find-first are used to fetch a SINGLE RECORD
2. For each statement is used to fetch the MULTIPLE RECORDS

• PRIMARY KEY INDEX
• UNIQUE index
• WORD index

Only ONE PRIMARY KEY in a SINGLE table

Only one primary key in a single table

• ERROR
• Num-Messages
• Get-Number
• Get-Message

USING ERROR-status FUNCTION we can TRACK the error in the STATEMENT.

Using error-status function we can track the error in the statement.

• Down
• ONE Down

FRAME is a rectangular DISPLAY AREA with in the WINDOW. It is used to display field level widgets.

Frame is a rectangular display area with in the window. It is used to display field level widgets.

FUNCTION is a sub-program like procedure but it can RETURN only one SINGLE VALUE.

Function is a sub-program like procedure but it can return only one single value.

1. Procedure DRIVEN MODEL (CUI)
2. Event driven model (GUI)

SYNTAX:

DEFINE &LT;parameter-type> parameter <parameter NAME> as <data-type> no-undo.

Example: Define INPUT parameter ip_a as integer no-undo.

Syntax:

Define <parameter-type> parameter <parameter Name> as <data-type> no-undo.

Example: Define input parameter ip_a as integer no-undo.

1. INPUT
2. OUTPUT
3. Input-output

The PARAMETER is used to PASSING the ARGUMENT to FUNCTION and procedure.

The parameter is used to passing the argument to function and procedure.

Run <EXTERNAL PROCEDURE name> PERSISTENT set <HANDLE VARIABLE Name>

Run <external procedure name> persistent set <Handle Variable Name>

It’s the PROCEDURE which keeps the value of the external procedure using handle variable. This variable will be valid until we CLOSE the PROGRESS session.

It’s the procedure which keeps the value of the external procedure using handle variable. This variable will be valid until we close the progress session.

1. INTERNAL PROCEDURE
2. EXTERNAL procedure
3. PERSISTENT procedure
4. SUPER procedure

Prompt-for: This is USED to GET input for both VARIABLE and database.

SET: This is used to get input only for variable.

Prompt-for: This is used to get input for both variable and database.

Set: This is used to get input only for variable.

Editing BLOCK is used to GET the input from the USER:

• Prompt-for
• Set 
• Update

Editing block is used to get the input from the user:

It’s a BLOCK which contains one or more STATEMENTS. WHENEVER an event occurs the CORRESPONDING trigger block will be FIRED.

It’s a block which contains one or more statements. whenever an event occurs the corresponding trigger block will be fired.

• REPEAT, do, for-each BLOCK
• PROCEDURE block
• TRIGGER block
• EDITING block

NUM-ENTRIES is used to RETURN the no of entries available in the list .

SYNTAX: Num-entries(<variable-list&GT;).

NUM-ENTRIES is used to return the no of entries available in the list .

Syntax: Num-entries(<variable-list>).

It is used to EXTRACT a string from the LIST. This FUNCTION takes two parameters ONE is the position of the string and another one is the list.

Syntax: Entry (&LT;Position of a String><variable-List>).

It is used to extract a string from the list. This function takes two parameters one is the position of the string and another one is the list.

Syntax: Entry (<Position of a String><variable-List>).

1. REPEAT
2. Do
3. For-each
4. Do-while

TWO TYPES of DATE FORMAT AVAILABLE:

1. MDY
2. DMY

Two types of date format available:

WHENEVER we change the VALUE of a variable, it will store the PREVIOUS value into the before IMAGE file. To avoid this reason, we are using no-undo while DECLARING the variable.

Whenever we change the value of a variable, it will store the previous value into the before image file. To avoid this reason, we are using no-undo while declaring the variable.

DEFINE variable <variable-name&GT; as <data-type>format<format-value> INITIAL <initial-value> no-undo

Example: Define variable lv_a as INTEGER format 999 initial 1 no-undo.

Define variable <variable-name> as <data-type>format<format-value> initial <initial-value> no-undo

Example: Define variable lv_a as integer format 999 initial 1 no-undo.

Syntax:

MESSAGE “&LT;message TEXT>” view-as alert-box <message type> buttons <button type>

Message type:

•  Information
•  Question
•  Error
• WARNING

Buttons:

• Ok
• Yes-No
• Yes-No-Cancel

Example:Message “welcome to progress” view-as alert-box information buttons ok.

Syntax:

Message “<message text>” view-as alert-box <message type> buttons <button type>

Message type:

Buttons:

Example:Message “welcome to progress” view-as alert-box information buttons ok.

• CUI (PROCEDURE EDITOR)
• GUI (ADM-2)

• The latest version of the PROGRESS 4GL is 10.1 OPEN EDGE
• The CURRENTLY working version is progress 9.1D

• Less development effort
• Solve more COMPLEX application
• Support multiple language
• Reusability
• Less KNOWLEDGE required for platform and deployments
• Support application server and WEB based application
• It is USED for both front-end and back-end.