Perguntas e Respostas usadas em Entrevistas de Progress 4GL

PROGRESS 4GL Question and Answer
Updated on 21-06-06 by NANDA

1. What are the advantages in progress 4GL?
2. What is the latest version in progress and in which are currently working?
3. What are the two ways of programming in progress?
4. What is the syntax for message statement?
5. What is the syntax for RUN statement?
6. What are the data types in progress?
7. What is the syntax for variable declaration?
8. Why we are using NO-UNDO?
9. How many date formats available in progress?
10. What are the types of looping statement?
11. What is the syntax for REPEAT loop?
12. What is the syntax for FOR-EACH loop and use of FOR-EACH loop?
13. What is the use of EntrY?
14. What is the use of num-entries?
15. What are the types of blocks?
16. what is trigger Block?
17. What is Editing Block?
18. What is the difference between prompt-for & set?
19. What are the types of procedures?
20. What is persistent procedure?
21. How will you Run External procedure persistently?
22. What is the use of parameter?
23. What are the types of parameters?
24. How will you define a parameter?
25. What are the types of programming models?
26. What is Function?
27. What is the syntax for function?
28. What is a FRAME?
29. What are the types of frames?
30. How will you track the error in the statement?
31. What are the methods in ERROR-STATUS?
32. Which is default & unknown Frame?
33. How many files are created for new Database?
34. How many primary keys will be in a single table?
35. What are the types of INDEXES?
36. How will you fetch Single record & multiple records?

37. What is the difference between FIND & FIND-FIRST?

1. What is the difference between FIND-FIRST and FOR-FIRST?
2. What is the use of NO-ERROR?
3. What is the use of XREF?
4. What is the syntax for XREF?
5. What is record scoping?
6. What are the types of scoping and their uses?
7. What is the use of LOCKS?
8. What are the types of LOCKS?
9. What is the syntax to release the LOCK Explicitly?
10. What is DEADLOCK?
11. What is TRANSACTION?
12. How will you identify the TRANSACTION?
13. What are the types of TRANSACTION?
14. What is SUB-TRANSACTION?
15. What is the use of CAN-DO, LOOK-UP, TRIM, SUBSTRING?
16. What is EVENT?
17. What is the use of SKIP?
18. What are the types of validation?
19. What are Import & Export and their uses?
20. What is TRIGGER?
21. What are the types of TRIGGERS and their uses?
22. What is the syntax for creating a trigger?
23. What is the use of CAN-FIND?
24. How will you Enable & Disable the trigger?
25. What is the advantage of Disabling TRIGGER?
26. What are the types of tables?
27. Difference between [or] Drawbacks of WORK-TABLE & TEMP-TABLE?
28. How will you define [Syntax] WORK-TABLE & TEMP-TABLE?
29. What is the location of TEMP-TABLE?
30. What is BROWSE-WIDGET?
31. What are the types of BROWSE-WIDGET & Selection BROWSE?
32. What is the default LOCK for Browse Widget?
33. What is query?
34. How will you define Query & Browse?
35. What are the EVENTS for BROWSE-WIDGET?
36. What is BUFFER-COPY?
37. What is pre-processor & Types?
38. What are the types of menus?
39. What is .PF file?
40. What is INCLUDE-FILE?
41. How to pass parameters to include file?
42. What is ETIME?
43. What is the use of ETIME & what does it Returns?
44. How will you define Static and Dynamic Query?
45. What is the use of Delimiter?
46. What is the use of NO-WAIT?
47. What is the use of Return-No Apply?
48. How to define Array?
49. Tools to develop web based Application?
50. Can we create a word-index for an array field?
51. Types of widgets?
52. How will Enable and Disable Widget?
53. What is Assign statement?
54. How will you remove super procedure?
55. Difference b/w SUPER & PERSISTENT Procedure?
56. How to Exclude in Export /Import statement?
57. Syntax for BUFFER-COPY?
58. How to identify whether the record is locked?
59. What is the exe file to start and shutdown the database for multi-user environment?
60. How many ways are there to pass parameter values?
61. How to define shared variables?
62. How to pass temp-table as parameter?
63. How will you clear the frame?
64. How will you hide & view the widget?
65. Syntax for COMBO-BOX?
66. How to add the list in combo-box?
67. Return type of available?
68. Is it possible to remove External & Internal procedure from the memory?
69. How to backup the database?
70. Different type of mode in application server?
71. What is whole-index?
72. What is the use of GroupAssign link?
73. What is the property to enable/disable the widget?
74. What is frame flashing?
75. What is the use of No-Lock statement?

PROGRESS 4GL Question and Answer Updated on 21-06-06


1. What are the advantages in progress 4GL?

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

2. What is the latest version in progress and in which are currently working?

The latest version of the PROGRESS 4GL is 10.1 Open Edge

The currently working version is progress 9.1D

3. What are the two ways of programming in progress?

CUI (Procedure Editor)

GUI (adm-2)

4. What is the syntax for message statement?

Syntax:

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


5. What is the syntax for RUN statement?

Syntax:

RUN <internal/external> procedure name

Example:

RUN calculator.p



6. What are the data types in progress?

ü Character

ü Integer

ü Decimal

ü Logical

ü Date

ü Handle

ü Widget-Handle

ü Com-handle

ü Rowid/Recid

7. What is the syntax for variable declaration?

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.

8. Why we are using NO-UNDO?

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.

9. How many date formats available in progress?

Two types of date format available

MDY

DMY

10. What are the types of looping statement?

Repeat

Do

For-each

Do-while

11. What is the syntax for REPEAT loop?

Repeat :

Statements…..

End.



12. What is the syntax for FOR-EACH loop and use of FOR-EACH loop?

Syntax:

For each <table name>:

Statements…..

End.

Use:

For each loop is used to fetch records one by one from one or more tables with or without where clause from the database.

13. What is the use of EntrY?

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

14. What is the use of num-entries?

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

Syntax:

Num-entries(<variable-list>).

15. What are the types of blocks?

Repeat, do, for-each block

Procedure block

Trigger block

Editing block

16. what is trigger Block?

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

17. What is Editing Block?

Editing block is used to get the input from the user

· Prompt-for

· Set

· Update

18. What is the difference between prompt-for & set?

Prompt-for:

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

Set:

This is used to get input only for variable.



19. What are the types of procedures?

Internal procedure

External procedure

Persistent procedure

Super procedure

20. What is persistent procedure?

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

21. How will you Run External procedure persistently?

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

22. What is the use of parameter?

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

23. What are the types of parameters?

Input

Output

Input-output

24. How will you define a parameter?

Syntax:

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

Example:

Define input parameter ip_a as integer no-undo.

25. What are the types of programming models?

Procedure driven model (CUI)

Event driven model (GUI)

26. What is Function?

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

27. What is the syntax for function?

Syntax:

Function <function-name> return <data-type> (Parameter type) <parameter-Value> as <data-type> [forward]

Statements……

End function

Example:

Function calculate return integer (input lv_a as integer, input lv_a as integer)

lv_a + lv_b.

End function



28. What is a FRAME?

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

29. What are the types of frames?

Down

One Down

30. How will you track the error in the statement?

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

31. What are the methods in ERROR-STATUS?

Error

Num-Messages

Get-Number

Get-Message

32. Which is default & unknown Frame?

Default frame is

Repeat

For each

Do with frame

Procedure blocks

Unknown frame is

do

33. How many files are created for new Database?

Five files will be created. They are

.db => default database file

.b1 => before image file

.d1 => after image file

.lg => log file

.st => size and location of the database

34. How many primary keys will be in a single table?

Only one primary key in a single table

35. What are the types of INDEXES?

Primary key index

Unique index

Word index

36. How will you fetch Single record & multiple records?

For-first and find-first are used to fetch a single record

For each statement is used to fetch the multiple records



37. What is the difference between FIND & 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

38. What is the difference between FIND-FIRST and FOR-FIRST?

For-first:

Using field option for specify the field name for modification

Using multiple index

Using word index field

Find-first:

In find first not support the above three statements

In find first we use no-error and available option

39. What is the use of NO-ERROR?

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

40. What is the use of XREF?

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

41. What is the syntax for XREF?

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

42. What is record scoping?

To identify the scope of the record

43. What are the types of scoping and their uses?

Weak scope .

eg :- for each loop

Strong scope

eg :- Do for loop

44. What is the use of LOCKS?

It is used to control the data access in the multi-user environment

45. What are the types of LOCKS?

Share-lock

Exclusive-lock

No-lock

46. What is the syntax to release the LOCK Explicitly?

Release <table-name> no-error

47. What is DEADLOCK?

Deadlock is situation at which the transaction will not be able to continue.

If we are not using proper locking statement then deadlock will occur.

48. What is TRANSACTION?

Set of changes into the database to be accepted / rejected by the system which is called transaction

49. How will you identify the TRANSACTION?

Using the following three steps we can identify that the transaction is available or not

ü The statements which is directly interact to the database use create update delete insert

ü When we use the TRANSACTION statement explicitly

ü Fetching record using exclusive-lock statement

50. What are the types of TRANSACTION?

i) Transaction

ii) Sub Transaction


It can also be a Larger Transaction (nested transaction) or a Smaller Transaction

(Repeat transaction, do transaction, etc.,)


51. What is SUB-TRANSACTION?

A sub transaction is nested in a transaction and encompasses all activity within one iteration of the following kinds of blocks: DO ON ERROR, FOR EACH, procedure, REPEAT, and triggers.


52. What is the use of CAN-DO, LOOK-UP, TRIM, SUBSTRING?

Can-do:

Can-do is used to find whether an entry is available in the list or not. It returns the Boolean value.

Syntax:

Can-do (<list>, <string-value>)

Lookup:

Lookup is used to find whether a given string is available in the list or not return position of a string as integer

Syntax:

Lookup (<string-value>,<list>).

Trim:

Removes leading and trailing white space, or other specified characters, from a character string.

Syntax:

Trim (<String Value>[, character-value])

Substring:

Extracts a portion of a character string from a field or variable



Syntax:

Substring (<String-value>, starting-pos [, length])

53. What is EVENT?

An action associated with a trigger and an object or a database. This is called event

54. What is the use of SKIP?

Skip statement, which is used to move the cursor position to the next line

55. What are the types of validation?

Blank validation

Data validation

Duplicate validation

Field level validation

Client level validation

Server level validation

56. What are Import & Export and their uses?

Import statement which is used to creating record from file which may be word or excel etc…

Export statement which is used to export the data from database into the file such as word/excel /printer/screen

57. What is TRIGGER?

A sequence of statement which is executed when an event occurs

58. What are the types of TRIGGERS and their uses?

Two types of triggers they are

Schema/Database trigger

Whenever a specific database event occurs such as creating or deleting a table, assigning a value to a field, and so on.

E.g. :-

Create , write , delete , etc.,

Session/User interface trigger

An action the user initiates on a widget with a keystroke or a mouse--such as pressing the GO key or marking a widget--executes a user interface trigger

Eg :-

Return, leave, entry, etc.,


59. What is the syntax for creating a trigger?

Syntax:

Trigger procedure for <trigger-type> of table.

Statements…….

Example:

Trigger procedure for create of customer.

assign customer.cust-num = next-value(next-cust-num).

60. What is the use of CAN-FIND?

Can-Find function which is used to find the availability of the record

Which is returns the Boolean value. This is faster than find first


61. How will you Enable & Disable the trigger?

Syntax:

Enable Triggers For {Dump | Load} Of <Table-Name>

Disable Triggers For { Dump | Load } Of <Table-Name>

Example:

Enable Triggers For Load of customer.

Disable Triggers For Load of customer.

62. What is the advantage of Disabling TRIGGER?

To improve the performance of the database transaction. To avoid the progress error while backup the database

63. What are the types of tables?

Temp table

Work table

64. Difference between [or] Drawback of WORK-TABLE & TEMP-TABLE?

Work – Table


Temp - Table

ü It is used before progress version 9.0

ü Stored in memory

ü We can store lesser volume of data

ü Cannot inherit or create index for tables

ü Can be able to store lesser volume of data

ü There is no empty statement to clear the work table


ü It will be frequently used from progress version 9.0

ü It will replace the work-table

ü Stored in the disk

ü We can store huge volume of data based on the disk size

ü When we inherit the database table index and also we can create our own index

ü Empty temp-table statement used to clear the table



65. How will you define [Syntax] WORK-TABLE & TEMP-TABLE?

Work-Table:

1. Define work-table <table-name> like <database-name>

2. Define work-table <table-name>

field1<field-name> as <data-type>

field2<field-name> as <data-type>

etc…..

field (n)<field-name> as <data-type>

Temp-Table:

1. Define temp-table <table-name> like <database-name>

2. Define temp-table <table-name>

field1<field-name> as <data-type>

field2<field-name> as <data-type>

etc…..

field(n)<field-name> as <data-type>

66. What is the location of TEMP-TABLE?

The location can be specified using –T parameter

67. What is BROWSE-WIDGET?

To display the records as row and column format like a data grid

68. What are the types of BROWSE-WIDGET & Selection BROWSER?

There are two types of browsers

1. Updatable browser

2. Non-updatable browser

There are two types of selection browser

1. single select browser

2. multi select browser

69. What is the default LOCK for Browse Widget?

The default lock of the browser widget is No-Lock

70. What is query?

Its is an instruction that tells the Progress to fetch the records from one or more tables in given database.

71. How will you define Query & Browse?

Define query <query-name> for <table-name> scrolling

Define browse <browse-name> query <query-name>

Display <field1><field2>……<field-n>

Enable <field1><field2> ……<field-n>

With <no-of-records to be displayed> down title <browse-title>

72. What are the EVENTS for BROWSE-WIDGET?

1. Value-changed

This is fired when moving between records.

2. Row-leave

This is fired on pressing tab key

3. Default action

This is fired on double clicking on the browser

o Mouse-double-click/mouse-select-click


73. What is BUFFER-COPY?

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

74. What is pre-processor & Types?

The frequently used values and statements are defined as PRE-PROCESSOR.

Pre-processor is used to understand the program easily.

Types of pre-processor:

& global-define <global-variable> <value>

& scope-define <local-variable> <value>

75. What are the types of menus?

Two types of menus

Drop-down menu

Pop-up menu

76. What is .PF file?

.pf is a parameter file. Collection of startup parameter can be initialized

77. What is INCLUDE-FILE?

Used to create for frequently used codes

File extension will be (.i)

Can be include in (.w, .p) files

78. How to pass parameters to include file?

We can pass parameter to the include files using (&) symbol

79. What is ETIME?

E-Time is elapsed time.

80. What is the use of ETIME & what does it Returns?

It is used to find out the time taking for execution of a particular block

It returns milliseconds

81. How will you define Static and Dynamic Query?

Static Query :

Define Query <query-name> for <table-name>

Dynamic Query:

Create Query <hdl_var_name>.

<hdl_var_name> : Set-Buffers(<buf_hdl>).

<hdl_var_name> : Query-Prepare(<Query>).

<hdl_var_name> : Query-Open().


82. What is the use of Delimiter?

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

83. What is NO-WAIT?

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.

84. What is the use of Return-No Apply?

It is mainly used in the gui. no-apply is suppressed default behaviors of the current user interface

85. How to define Array?

Syntax:

Define Variable <Array-Variable> As <data-type> Extent <N>

Example:

Define variable lv_a as integer extent 10.

86. Tools to develop web based Application?

Web-speed 3.0 is a software, which is used to develop web-based applications.

Web client is a software where client/Server applications will be accessed using browser like Netscape or Internet Explorer

87. Can we create a word-index for an array field?

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

88. Types of widgets?

Windows

Frames

Dialog boxes

Browse

Fill-in fields, text, sliders, selection lists, combo boxes, toggle boxes, radio sets, and editors for data representation

Buttons, images, rectangles, and literals

Menus, submenus, menu bars, and menu items

89. How will Enable and Disable Widget?

To enable the widget :

Widget : sensitive = True

To disable the widget :

Widget : sensitive =False

90. What is Assign statement?

To combine more than one statement into a single statement.

91. How will you remove super procedure?

Remove-super-procedure () method is used to remove the procedure from super procedure




92. Difference b/w SUPER & PERSISTENT Procedure?

Super procedure:

Super procedure can be overridden

Super procedures can be executed without using the handle whereas the persistent

Example:

Run calculate.

Persistant procedure:

Persistent procedure can’t overridden.

procedures needs the handle to run the procedure.

Example:

Run calculate in lv_handle.

93. How to Exclude in Export /Import statement?

By using the ‘except’ option we can exclude the unnecessary fields in export and import statement.

94. Syntax for BUFFER-COPY?

Buffer-copy <source-name> to <target-name>

BUFFER-COPY

source [ { EXCEPT | USING } field ... ]

TO target [ ASSIGN assign-expression ... ] [ NO-ERROR


95. How to identify whether the record is locked?

Using the locked method we can identify the record is locked

Locked <table-name>

Eg :-

For first customer exclusive-lock.

If locked (customer) then

Message “Locked” view-as alert-box.


96. What is the exe file to start and shutdown the database for multi-user environment?

_mprosrv.exe this file is used to start the database for multi-user environment

_mprshut.exe this file is used to shutdown the database for multi-user environment

97. How many ways are there to pass parameter values?

Parameter

Pre-processor

Shared-variable

Temp-table

Persistant procedure

98. How to define shared variables?

When the variable is declared for the first time it has to be said as new shared variable .

After that whenever we share the variable we can declare as shared variable.


Syntax:-

Define New shared variable <variable-name> as <data-type> initial <initial-value>

Define shared variable <variable-name> as <data-type> initial <initial-value>

99. How to pass temp-table as parameter?

Temp-table can be passed as parameter by using the ‘Table’ keyword with the parameter type in a function or procedure and it can be received by using ‘Table for <local table name>’ keyword in define parameter statement.

100. How will you clear the frame?

Using clear frame statement we can clear the frame

Syntax:

Clear frame <frame-name>

101. How will you hide & view the widget?

Hide Object:

Syntax:

<widget-handle>:hidden = true.

Example:

btn_seach: hidden = true.

View Object:

Syntax:

<widget-handle>:hidden=false.

Example:

btn_search: hidden = false.

102. Syntax for COMBO-BOX?

Syntax:

Define variable <variable-name> as <data-type> view-as combo-box list-item <”item1”,”item2”,…”item-n> no-undo label <”label-name”>

Example:

Define variable lv_sex as character view-as combo-box list-item “male”,”female” no-undo label “Sex”.

103. How to add the list in combo-box?

Syntax:

<Combo-box-name> : addItem (list [,list]).

Example:

Cmb_sex : additem(“MALE”,”FEMALE”).

104. Return type of available?

Return type of available is logical. This is returns true/false/unknown(?)

105. Is it possible to remove External & Internal procedure from the memory?

No we cannot remove the External and internal procedure.


106. How to backup the database?

Using Probkup.exe we can backup the database.

Syntax:

Probkup.exe <source-DB> <Destination-DB>

Example:

Probkup.exe customer tt_customer.

107. Different type of mode in application server?

i) Stateless

ii) State Aware

iii) State Reset

108. What is whole-index?

Whole index can be used without specifying where clause in the for each statement. Progress searching a record using the entire index but often primary index.

109. What is the use of GroupAssign link?

Group of viewers can be linked using group assign link. In this case first viewer having update and tableIO link and remaining viewers will not have these links, viewer 1 will act as a source , remaining viewers will be target

Syntax :

Source linktype Target

For single SDO

Viewer1 update SDO

updatepanel tableIO viewer1

Viewer1 groupassign viewer2

Viewer1 groupassign viewer3


Suppose if we have more number of fields then we cannot put all into a single viewer so we will divide group of fields to different viewers using the groupAssign link.

110. What is the property to enable/disable the widget?

To enable the widget :

Widget : sensitive = True

To disable the widget :

Widget : sensitive =False

111. What is frame flashing?

A phenomenon called frame flashing occurs when an iterating block displays to a frame that is scoped to an enclosing block.

To avoid the frame flashing we are using down

Example:

Form Customer.Cust-Num Customer.Name Customer.Credit-Limit

With Frame Cust-Frame.

For Each Customer:

Display Cust-Num Name Credit-Limit With Frame Cust-Frame.

End.








ADM-2


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.

2. What is smart container?

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

3. What are the types of smart panel?

They are two panels:

Update panel.

Navigational panel.

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

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


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

To Hide Object :

Run HideObject <Object name>

To View Hidden Object :

Run ViewObject <Object name>

7. What are the types of row object table?

1. Row Object table.

2. Row Object Update Table.

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

9. How will you get viewer handle from SDO?

Syntax:

Dynamic-Function (‘getUpdateSource’).

Example:

Dynamic-Function(‘getupdatesource’).

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

Syntax:

Dynamic-Function (‘getDataSource’).

Example:

Dynamic-Function(‘getdatasource’).

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

Syntax:

Dynamic-Function (‘getContainerSource’).

Example:

Dynamic-Function(‘getContainerSource’)

12. How to get query for SDO?

Syntax:

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

Example:

Dynamic-Function(‘getquerywhere’ in h_dcust1000).

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

14. How to open query in SDO?

Syntax:

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

Example:

Dynamic-function(‘openquery’ in h_dcust1000).

15. What is the flow of smart object?

i) Construct Object

ii) Initialize

iii) Main Block

16. How to select a particular page?

Syntax:

Run selectPage(<page no>)

Example:

Run selectpage (‘1’).

17. How to Hide/View object?

To Hide an object :

Widget : Hidden = true.

To View a hidden object:

Widget : Hidden = false.

18. What are the types of smart links?

i) Data

ii) Update

iii) Table IO

iv) Page

v) Navigation

vi) GroupAssign

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

20. What is data available procedure?

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

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

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


23. How to get RowIdent in SOD?

dynamic-function(‘getRowident’ IN SDO_hdl)

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

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

26. What is CRC?

CRC-cyclic redundancy code

When ever we make any changes in the database. We need to recompile the files against the new changes otherwise we get the CRC error. we are using application compiler for compile these files.

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