Home » Developer & Programmer » Forms » CHECK RUN TIME WHICH FIELD VALUE UPDATED (ORACLE FORM 6I)
icon2.gif  CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607483] Fri, 07 February 2014 02:40 Go to next message
bpmehta
Messages: 3
Registered: February 2006
Location: india
Junior Member

Hi friends,

I am using oracle form 6i having multiple location data in one table now want to make such facility that if user change any field value by login in any one location system should ask for change this value to other location also?? How can I such generate effectivly.
any idea ...
Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607484 is a reply to message #607483] Fri, 07 February 2014 02:46 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid I don't understand what you are saying. Could you provide an example of the above "description"? Please, use punctuation - it makes your thoughts much more clear.

Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607485 is a reply to message #607484] Fri, 07 February 2014 03:13 Go to previous messageGo to next message
bpmehta
Messages: 3
Registered: February 2006
Location: india
Junior Member

Thanks for respond , I want to say that
For example table itemmaster having ,
location code, material code , stock , unit,type
1155,MONITOR,10,NOS,INDENT
1155,OIL,5,LTR,INDENT
1100,MONITOR,5,BOX,INDENT
1199,MONITOR,15,BOX,REORDER
1188,OIL,15,KG,INDENT

as you can see that having different location wise record created now from form if I changed in location 1100 MONITOR unit from BOX to Nos system should asked that do you want to change for the same item in other location based record . So I donot need to update each location . I have given example for unit field if user change type filed then also system should ask for updation, User can not update locaton and Material code ...
Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607487 is a reply to message #607485] Fri, 07 February 2014 03:42 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
WHEN-VALIDATE-ITEM fires when you change "BOX" to "Nos". Therefore, check whether there are other locations that contain the same MATERIAL_CODE whose UNIT_TYPE is different from "Nos". If so, ask user whether he'd want you to change these UNIT_TYPEs for him. If so, write an UPDATE statement that will do that.
Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607489 is a reply to message #607487] Fri, 07 February 2014 03:52 Go to previous messageGo to next message
cookiemonster
Messages: 10980
Registered: September 2008
Location: Rainy Manchester
Senior Member
If the other records that need updating are also in the datablock that will lead straight to:
FRM-40654: Record has been updated by another user. Re-query to see change

There is no nice way to do this that I know of.
Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607491 is a reply to message #607489] Fri, 07 February 2014 04:04 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Right; apart from doing update + execute_query afterwards (unfortunately, that can't be done in WHEN-VALIDATE-ITEM trigger).
Re: CHECK RUN TIME WHICH FIELD VALUE UPDATED [message #607492 is a reply to message #607489] Fri, 07 February 2014 04:15 Go to previous message
bpmehta
Messages: 3
Registered: February 2006
Location: india
Junior Member

Thanks both of you
but using WHEN-VALIDATE-ITEM i have to write code for each item(Field) is there any better alternative so I donot need to write each field as user can change any field value at run time
Previous Topic: CLOSE ALL FORMS using the WHEN-WINDOW-ACTIVATED trigger
Next Topic: Export to excel on screen data in oracle Forms
Goto Forum:
  


Current Time: Tue Sep 30 10:43:00 CDT 2014

Total time taken to generate the page: 0.05087 seconds