In the Manual datablock , we will get records from database then I need to get each row in different color ......I am using the set_item_property('blockname.item',current_row_background_color,'red');plz help me.............

asifinet

 Profile Answers by asifinet Questions by asifinet

• Feb 16th, 2013

You can use SET_BLOCK_PROPERTY(blk_name,record_no, CURRENT_RECORD_ATTRIBUTE,Visual_attribute_name); Must create two Visual Attributes one with yellow background color one with default name them VA_Y...

SANJIT

• Jan 20th, 2013

Code
 

Answer Question  Select Best Answer

 255 character width and 255 characters  Length.

Kareem

• Apr 3rd, 2007

This is the max number of form name not the entire form size

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

The maximum size of a form is 255 character length and 255 character width.

Answer Question  Select Best Answer

 Select the use constraint property is ON Block definition screen. BLOCK

i.govardhan

 Profile Answers by i.govardhan Questions by i.govardhan

• Sep 18th, 2008

We control the constraints in forms while selecting primary key 'yes' in property palett.

parash_3380

 Profile Answers by parash_3380 Questions by parash_3380

• May 4th, 2006

Hi,we control the constraints in forms while selecting primary key 'YES' in property palette.

Answer Question  Select Best Answer

i.govardhan

 Profile Answers by i.govardhan Questions by i.govardhan

• Sep 18th, 2008

Post-block is navigational trigger

mukts

• Mar 31st, 2006

Navigational Trigger.

Answer Question  Select Best Answer

 Only When-checkbox-activated Trigger associated with a Check box.  

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

1.       WhEN-VALIDATE-ITEM2.       WHEN-NEW-ITEM-INSTANCE3.       WHEN-CHECKBOX-CHANGED

ashly

• Apr 18th, 2006

when_checkbox_changed

Answer Question  Select Best Answer

 Display  items are similar to text items but store only fetched or assigned values.  Operators  cannot  navigate to a display item or edit the value it contains.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

Display items and text items are fairly similar and share many of the same properties. The biggest difference between the two is that a user can navigate to a text item and change its value. This is not possible with a display item. As its name implies, it merely displays information.

Sailaja Pasupuleti

• Dec 4th, 2005

Display items are non-input items.  User cannot navigate into such type of item either with keyboard or mouse.  For derived values user can use display item.

Answer Question  Select Best Answer

 It is a list of text elements.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

List items are exactly what their name implies—a short list of values that the user can choose from. List items can serve as either database or non-database items.They present the user with a nu...

Sailaja Pasupuleti

• Dec 4th, 2005

     To understand list item, take MS-Word application.  If user wants to change the text Font then user can choose/select a required Font from the available list (called list...

Answer Question  Select Best Answer

 Poplist, No text Item displayed in the list item.   Tlist, No element in the list is highlighted.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

There are three types of list items: poplists, Tlists, and combo boxes. Poplists, which are the default type. They restrict the user from selecting only from the list elements that are displayed. A co...

Shweta_faqs

 Profile Answers by Shweta_faqs Questions by Shweta_faqs

• Nov 2nd, 2005

Poplist (drop list)T-list (List box)Combo Box

Answer Question  Select Best Answer

 Radio  groups  display  a fixed no of options that are mutually Exclusive .User can select one out of n number of options.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

Radio groups are logical containers of radio buttons. Radio buttons are the small circles that appear on the screen which the user can click to select values. Radio group selections are mutually exclusive. That is, selection of one radio button deselects the previously selected button.

Shweta_faqs

 Profile Answers by Shweta_faqs Questions by Shweta_faqs

• Nov 2nd, 2005

A group of radio buttons one of which is always selected.

Answer Question  Select Best Answer

 Unlimited no of radio buttons can be assigned to a radio group

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

A good rule of thumb is to have no more than six radio buttons in a radio group. If there are going to be more than six, you might want to consider using a list item, which provides similar functional...

sri ganesh

• May 29th, 2006

hai,   this answer is : Depending on Application.                       &nb...

Answer Question  Select Best Answer

 Custom Visual attributes   Default visual attributes   Named Visual attributes. Window

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

There are three values for the Visual Attribute Type property:1) Common, which for text and display items applies to the item itself and its prompt. Common visual attributes can also be used for other...

Shyamal Kumar

• Mar 18th, 2006

Visual attribute type are1.)Common2.)Prompt3.)Title

Answer Question  Select Best Answer

semaj

 Profile Answers by semaj Questions by semaj

• Feb 27th, 2007

Create an ON-LOCK trigger and code along these lines ....declare  cursor c1 is   select * from emp  where empno = :emp.empno  for update nowait;  r1    &nb...

manish

• Sep 17th, 2006

When-new-record-instance--set property 'enter-query mode' YES (default)Use 'For Update Cursor' with 'NoWait' for firing DMLs on table.For Update Clause explicitly lock the table before you fire any DM...

Answer Question  Select Best Answer

 INP (Source File)   FRM (Executable File)

parash_3380

 Profile Answers by parash_3380 Questions by parash_3380

• May 4th, 2006

Hiit create two files with extension FMB - Contains source codeFMX - It is executable file.

Amit Chintawar

• Mar 29th, 2006

FMB- You can open this fileFMX- This is in Executable mode, you cannot open this file

Answer Question  Select Best Answer

 No.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

no you can not make two blocks with same name,not only block for same type of object you can not have same name.

Answer Question  Select Best Answer

 using On-Message or On-Error triggers.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

other then on-error trigger , you can use  exception also in that blockwith the help of a small procedure and alert you can populate the message and with raise_form_trigger_failure transaction can be controlled.

Answer Question  Select Best Answer

 It  fires  when a value in a field has been changed and the field status is changed  or  new  and  the   key has been pressed. If the field status  is valid then any further change to the value in the field will not fire the on-validate-field trigger.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

On-validate field tigger will fire when ever cursor moves from that field to next field, so first key-next will fire then validate.

Answer Question  Select Best Answer

 When you changes the Existing  value to null, the On-validate field trigger will  fire  post change trigger will not fire. At the time of execute-query post-change trigger will fire, on-validate field trigger will not fire.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

On-validate field will fire after post-change trigger.  if value in field satisfy the validation then also post-change will fire when cursor leaves that field but after key-next

Answer Question  Select Best Answer

 When Execute-query or count-query Package procedures are invoked.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 6th, 2006

Pre-query trigger fires before any execution of a query.  this trigger fires only once per query. where as post query fires for each row.

Answer Question  Select Best Answer

 No.

raheemrao

 Profile Answers by raheemrao Questions by raheemrao

• Jun 1st, 2008

No, we cann't use go_block in pre_field trigger

Answer Question  Select Best Answer

 Erase removes an indicated global variable.

anitha palla

 Profile Answers by anitha palla Questions by anitha palla

• Aug 13th, 2010

Erase removes an indicated global variable and releases the memory associated with it.

Answer Question  Select Best Answer