Validation in POST-TEXT item trigger

11-30  Source: Network gathering  Views:0 

Does POST-TEXT -ITEM trigger fire in ENTER-QUERY mode?
If not suggest me solution for following scenario:
I have supplier field in master block. When Form is in -ENER-QUERY mode, i want to validate the user input in the supplier field before user navigate out of the field using TAB KEY (KEY-NEXT-ITEM) or MOUSE (POST-TEXT-ITEM).
The Forms help says that it doesn't, and nor does when-validate-item.
It looks like you'll have to use the when-new-item-instance trigger. You can store the value of the current field and whenever the trigger fires, run some code to validate that field. If it passes the validation then store the value of the new field, otherwise put the user back in the original field.
You'll also need to call the code from the key-exeqry trigger, so that you can validate the field which the user is in when they execute the query.
Related articles
  • Validation in POST-TEXT item trigger 11-30

    Hi Does POST-TEXT -ITEM trigger fire in ENTER-QUERY mode? If not suggest me solution for following scenario: I have supplier field in master block. When Form is in -ENER-QUERY mode, i want to validate the user input in the supplier field before user

  • Execute query when post text item 11-30

    Anybody can help ? I create 2 block, first a data block and another is a control block with field customer_search field, after inputing customer id in search field on control block, I want to execute query. my code : set_block_property('customer',def

  • Display Hint Text in Oracle Forms 6i at Text Item 10-11

    Dear all seniors I want to show Hint text at Text Item in Oracle Forms 6i. when my cursor Focus goes at that item. I mean when I go with Tab key or Enter button then it show display text. even though my mouse is not on that item. please how it would

  • Navigating to the text item with color 11-30

    hi all, i have 10 text_items in my form, i want that when i am in first text_item the color should change default to any color i want (take suppose yellow) then when i am going to second text_item then color should change to yellow like that it has t

  • How do you write UNDO for a text item?? examples? or a REDO?? 11-30

    How do you write UNDO for a text item?? examples? or a REDO?? I created a pop-up menu with CUT, COPY, PASTE, UNDO, CLEAR for my text items. Using MAGIC menu type works great but there is no MAGIC for UNDO or REDO..... How do you write UNDO for a text

  • Text item validation into Formular. 10-11

    hi. From some days I have written my fiirst application using Oracle Forms6i. In oracle9i I created table USER with column id_user number(5), username varchar2(10) and passwd varchar2(12). In oracle forms builder I created the formular with 4 control

  • Validation on text item 10-11

    Hi all, i have a text item P6_MAXLIABILITY I put a validation on that item with regular expression. I want that validation to happen, when the focus moves to the next item. could any one give me a suggestion? bye SrikaviHi, if the focus changes the j

  • How to call another form ,if option is entered in a text item object ??? 10-11

    hi , I am created an application ,where in i press a button which call another form having a menu . I select any one of the option from the menu ....i enter a number in the text item object of this form ....depending upon what option i have typed ...

  • Need code for this Small validation on when-validate-item 10-11

    Hi All, I have a text item(date datatype) in forms 4.5 I need to do a small validation want to write on when-validate-item. When I enter a date in that text item (Ex 10-JUN-2005) it has to check 1) It Cannot be "blank" 2) It cannot be "Not

  • How to validate a text item/display item in Oracle forms 9i? 11-30

    Hello Everyone, I have a form in which we have to type in a product_id as shown below in the screenshot. And when we type in, it has to get validated. If it is valid then ok, else display a message saying not valid. How do we achieve it on a text box

  • Change the color of text item after execute query 11-30

    Dear friends I would like to know how can I make a tabular form like grid and chang the color of text item when (for exp in emp table) the value of sal column between 2000$ and 4000$. I used the SE_IEM_PROPERTY command but it change all of the text i

  • TEXT ITEM from different table 11-30

    When a TEXT ITEM from different table exists in the DATA BLOCK, and when after EXECUTE_QUERY (in trigger POST_QUERY) we issue the SELECT for filling the TEXT ITEM from different table, how we can prevent FROM_STATUS and RECORD_STATUS to get the value

  • FRM-40735: When-Validate-Item trigger raised unhandled exception ORA-01861 11-30

    Dear all, I runned a form designed by Developer 2000 version 4.5 and encountered a puzzling problem. The same program could be runned on one computer but not in another one. The error message is as below: FRM-40735: When-Validate-Item trigger raised

  • Language restriction on Text Items. 11-30

    Hi, We are developing an application in Oracle 8i & Forms 6i for a Thailand based company. The users will enter data in English as well as Thai language. We have tested the forms that accepts both English & Thai characters in a single text item. T

  • How to populate sequence in a text item in a form 10-11

    I have a text item in a form.I want that the doc_id i.e the text item should be automatically populated with the help of sequence.I have created sequence named seq_doc_id.on which trigger i should write the code so that everytime the doc_id gets incr

  • Multiple values from database on a single text item 10-11

    i am trying to do the following on a single text item in a form (under form property pallete->records->number of items displayed is 5) run a triger "when-new-block-instance" with the following pl/sql statement declare menu_item VARCHAR2(35

  • Forms (V10G) - RunTime Text  Item -- Editor 10-11

    Hello: What are the available options to enhance forms runtime SYSTEM/DEFAULT editor for Text Items? We like to add spell checker, text format features in to field editor. I am sure there are Java based editors out there that Forms could invoke. I am

  • When-validate-item trigger restriction on open form or call form 10-11

    W have when-validate-item trigger. I need to place a code here that will bring up a form when the "valid entry" on the item has been made. I am getting a frm-40737:Illegal restricted procedure COMMIT... Code snippet on the procedure that I am ca

  • How i can assign multiple values to tabuler text item (Help) 10-11


  • How to disable a single row of a multi-line text item 10-11

    I am trying to disable a date and a price on each row where the date is current or in the past (on theory the user can't update reference data that is in effect or past, only data which is not yet in use). It appears that forms 6i will make this an a