Perguntas e Respostas usadas em Entrevistas de Progress 4GL - ADM2

1. What is Smart objects?

We can play in around with the object handle.so we called as smart object.

Advantage

Reusability

Less development effort

1. What are the types of smart object?

They are 9 Types:

Ø Smart Window.

Ø Smart Frame.

Ø Smart Dialog.

Ø Smart Data browser.

Ø Smart Data Viewer.

Ø Smart Folder.

Ø Smart Panel.

Ø Smart Data Object.

Ø Smart Filter.

1. What is smart container?

Collection of smart object can be placed on the smart container.

What is smart data object(SDO)?

The only one smart object which connect the database.

4. Frequently used functions for SDO?

Before going to use the following functions you should have the handle.

1. Open Queryà Refresh the data (all the rows).

2. GetrowIndentàcurrent record.

3. RowIdWhereàPass the dynamic query.

4. SetQueryWhereàChange the existing value

GetQueryWhereàwhere condition.

5. SetQuerySort/GetQuerySort

6. FetchRowIdent.

7. RefreshRowàRefresh the current row.

8. Addrow

9. Deleterow

10. Copyrow.

11. ColumnValue

12. GetColumnStringValue.



5. Pre-defined functions in ADM2

Adm-create-objects:(Progress Generated procedure) no override

All the smart objects can be seen with pageno.

Smart Folder(Tab strip)

We can place the objects in different pages.

Smart window

It’s a parent smart object.

Smart Frame/System Dialog

Its like child of smart window.

Smart Data Object(SDO)

Only one object that directly connects to the database.

6. What are the types of smart panel?

They are two panels:

Update panel.

Navigational panel.

7. How many files will be created while creating SDO?

They are five files:

1) .W

2) .R

3) _CL.R

4) _CL.W

5) .I

.W,.RàIt has procedure and function which need database connection.

-CL.W,-CL.Rà It has procedure and function which do not require database function.

.iàIt has all field informations.

8. What are the types of validation?

Client Level Validation

Validation in SDO:

In viewer we are make validation in the procedure of rowobjectvalidate

Validation in viewer:

In SDO we are using add-record, update-record, write-record

Server Level Validation.

In server side validation we are using the procedure in SDO

PreTransactionValidate

BeginTransactionValidate

EndTransactionValidate

PostTransactionValidate


9. How will you hide & view the smart object?

To Hide Object :

Run HideObject <Object name>

To View Hidden Object :

Run ViewObject <Object name>

10. What are the types of row object table?

1. Row Object table.

2. Row Object Update Table.

11. Where will you put validation in SDO?

For client side validation we are using the procedure

RowObjectValidate

For server side validation we are using the following procedure

PreTransactionValidate

BeginTransactionValidate

EndTransactionValidate

PostTransactionValidate

12. How will you get viewer handle from SDO?

Syntax:

Dynamic-Function (‘getUpdateSource’).

Example:

Dynamic-Function(‘getupdatesource’).

13. How will you get SDO handle from Browser/Viewer?

Syntax:

Dynamic-Function (‘getDataSource’).

Example:

Dynamic-Function(‘getdatasource’).

14. How will you get container handle from Browser/Viewer/SDO?

Syntax:

Dynamic-Function (‘getContainerSource’).

Example:

Dynamic-Function(‘getContainerSource’)

15. How to get query for SDO?

Syntax:

Dynamic-Function (‘getQueryWhere’ IN <SDO handle>).

Example:

Dynamic-Function(‘getquerywhere’ in h_dcust1000).




16. How to get the where clause to the SDO?

Syntax:

Dynamic-Function (‘getQueryWhere’ IN <SDO handle>, <Where Clause Condition>).

Example:

Dynamic-Function(‘getquerywhere’ in h_dcust1000,where_clause:screen-value).

17. How to open query in SDO?

Syntax:

Dynamic-Function (‘OpenQuery’ IN <SDO handle>).

Example:

Dynamic-function(‘openquery’ in h_dcust1000).

18. What is the flow of smart object?

i. Construct Object

ii. Initialize

iii. Main Block

19. How to select a particular page?

Syntax:

Run selectPage(<page no>)

Example:

Run selectpage (‘1’).

20. How to Hide/View object?

To Hide an object :

Widget : Hidden = true.

To View a hidden object:

Widget : Hidden = false.

21. What are the types of smart links?

i. Data

ii. Update

iii. Table IO

iv. Page

v. Navigation

vi. GroupAssign

Source


Link Type


Destination

SDO


Data


Browser

SDO


Data


Viewer

Navigation Panel


Navigation


SDO

Update Panel


TableIO


Viewer

Viewer


Update


SDO


21. How to add /Remove link during Runtime?

Adding link in runtime :

Syntax:

Run addLink(<Source>,<Type of link>,<Destination>)

Example:

Run addlink(h_vcust1000,update,h_dcust1000).

Removing link in runtime :

Syntax:

Run removeLink (<Source>,<Type of link>,<Destination>)

Example:

Run removeLink (h_vcust1000, update, h_dcust1000).

22. What is data available procedure?

Data Available procedure will hold the currently selected row of the browse widget.

23. How to get particular field value?

Getting particular field value :

Dynamic-function(‘column-name’ In handle-variable name,“cust-num”).

Dynamic-function(‘columnstringvalue’ In handle-variable name “name”).

Rowobject . <field name> : Screen-Value

Example:

rowobject.cust-num:screen-value.

24. How to add more then one buffer into query handle?

Using Add-Buffer method we can add more buffer into the query handle.

Syntax:

<query-handle-name>:set-buffers(<buffer-handle-name>).

<query-handle-name>:add-buffers(<buffer-handle-name>).

25. How to get RowIdent in SDO?

dynamic-function(‘getRowident’ IN SDO_hdl)

26. How will you convert RowIdent to RowId?

Using the to-rowID() method we can convert the rowident into row id

Example:

rowID(<table-name>) = to-rowID(dynamic-function(‘getRowident’ IN SDO_hdl))

27. What is smart filter?

This is used to search the records based on the SDO fields with different criteria like begins contains equal, not equal, greater then, less then etc….

28. How to get the current page?

Using this method we can get the current page

getcurrentpage()

Define variable lv_int as integer no-undo.

lv_int = getCurrentPage ()