Tag: Progress 4GL

Question 1. What Are The Advantages In Progress 4gl?

Answer :

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

Question 2. What Is The Latest Version In Progress And In Which Are Currently Working?

Answer :

• The latest version of the PROGRESS 4GL is 10.1 Open Edge
• The currently working version is progress 9.1D

Question 3. What Are The Two Ways Of Programming In Progress?

Answer :

• CUI (Procedure Editor)
• GUI (ADM-2)

Question 4. What Is The Syntax For Message Statement?

Answer :

Syntax:

Message “” view-as alert-box buttons

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.

Question 5. What Is The Syntax For Variable Declaration?

Answer :

Define variable as format initial no-undo

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

Question 6. Why We Are Using No-undo?

Answer :

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.

Question 7. How Many Date Formats Available In Progress?

Answer :

Two types of date format available:

1. MDY
2. DMY

Question 8. What Are The Types Of Looping Statement?

Answer :

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

Question 9. What Is The Use Of Entry?

Answer :

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

Question 10. What Is The Use Of Num-entries?

Answer :

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

Syntax: Num-entries().

Question 11. What Are The Types Of Blocks?

Answer :

• Repeat, do, for-each block
• Procedure block
• Trigger block
• Editing block

Question 12. What Is Trigger Block?

Answer :

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

Question 13. What Is Editing Block?

Answer :

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

• Prompt-for
• Set 
• Update

Question 14. What Is The Difference Between Prompt-for & Set?

Answer :

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

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

Question 15. What Are The Types Of Procedures?

Answer :

1. Internal procedure
2. External procedure
3. Persistent procedure
4. Super procedure

Question 16. What Is Persistent Procedure?

Answer :

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.

Question 17. How Will You Run External Procedure Persistently?

Answer :

Run persistent set

Question 18. What Is The Use Of Parameter?

Answer :

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

Question 19. What Are The Types Of Parameters?

Answer :

1. Input
2. Output
3. Input-output

Question 20. How Will You Define A Parameter?

Answer :

Syntax:

Define parameter as no-undo.

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

Question 21. What Are The Types Of Programming Models?

Answer :

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

Question 22. What Is Function?

Answer :

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

Question 23. What Is A Frame?

Answer :

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

Question 24. What Are The Types Of Frames?

Answer :

• Down
• One Down

Question 25. How Will You Track The Error In The Statement?

Answer :

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

Question 26. What Are The Methods In Error-status?

Answer :

• Error
• Num-Messages
• Get-Number
• Get-Message

Question 27. How Many Primary Keys Will Be In A Single Table?

Answer :

Only one primary key in a single table

Question 28. What Are The Types Of Indexes?

Answer :

• Primary key index
• Unique index
• Word index

Question 29. How Will You Fetch Single Record & Multiple Records?

Answer :

1. For-first and find-first are used to fetch a single record
2. For each statement is used to fetch the multiple records

Question 30. What Is The Difference Between Find & Find-first?

Answer :

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

Question 31. What Is The Difference Between Find-first And For-first?

Answer :

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

Question 32. What Is The Use Of No-error?

Answer :

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

Question 33. What Is The Use Of Xref?

Answer :

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

Question 34. What Is The Syntax For Xref?

Answer :

Compile save XREF

Question 35. What Is Record Scoping?

Answer :

To identify the scope of the record.

Question 36. What Are The Types Of Scoping And Their Uses?

Answer :

Weak scope .

        eg :-    for each loop

Strong scope

         eg :- Do for loop

Question 37. Tools To Develop Web Based Application?

Answer :

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.

Question 38. Can We Create A Word-index For An Array Field?

Answer :

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

Question 39. What Is No-wait?

Answer :

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.

Question 40. What Is The Use Of Delimiter?

Answer :

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

Question 41. What Is The Use Of Etime & What Does It Returns?

Answer :

1. It is used to find out the time taking for execution of a particular block
2. It returns milliseconds.

Question 42. What Is Buffer-copy?

Answer :

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.