Home » Developer & Programmer » Forms » change the name of the field (oracle 10g)
change the name of the field [message #432411] Tue, 24 November 2009 00:37 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
i have field called "pypstsm_date" and i wrote WHEN-NEW-ITEM-INSTANCE trigger on it to prevent going to next field when pressing tab, and this is the code:

message(':pypstsm_date',required);

so it is working but the problem is showing the name of the field
(pypstsm_date) in the bottom of the screen and i want to change it to just "DATE". How ??
Re: change the name of the field [message #432415 is a reply to message #432411] Tue, 24 November 2009 01:19 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
In my opinion, you are doing that in a wrong manner. If an item is "required", then set its "Required" property to Yes. Now Forms will take care of it automatically.

Alternatively, verification should be done in the WHEN-VALIDATE-ITEM trigger (not the one you are using). In that case, you'd write your own message and raise an exception, such as
if :pypstsm_date is null then
   message('Date should be entered');
   raise form_trigger_failure;
end if;


Besides, what about mouse navigation? You've said that you wanted to restrict <Tab> navigation (which is, actually, controlled by the KEY-NEXT-ITEM trigger).
Re: change the name of the field [message #432416 is a reply to message #432415] Tue, 24 November 2009 01:25 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
you are right ...but it is not working with my form, i don't know why ?? still keep going to another field when pressing tab. thank you for your reply
Re: change the name of the field [message #432417 is a reply to message #432416] Tue, 24 November 2009 01:34 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What exactly is not working? Setting item's "Required" property? WHEN-VALIDATE-ITEM trigger? Something different?
Re: change the name of the field [message #432420 is a reply to message #432417] Tue, 24 November 2009 02:33 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
YES... the property is working if i go from key block to master block when i prss ctl+page down then click tab...the cursor will stick in the pypstsm_date field in the master block but if i go back to the key block through ROLLBACK and press ctl+page down again to go to master block(pypstsm_date) field then pressing tab ...the cursor will go to the next field which is i don't want the cursor to move to the next field.
Re: change the name of the field [message #432423 is a reply to message #432420] Tue, 24 November 2009 03:03 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you try WHEN-VALIDATE-ITEM trigger?
Re: change the name of the field [message #432444 is a reply to message #432417] Tue, 24 November 2009 04:38 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
yes ..i have tried this one ...still not working
Re: change the name of the field [message #432462 is a reply to message #432411] Tue, 24 November 2009 06:02 Go to previous messageGo to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
i fixed the problem ...thank you so much for your reply.
Re: change the name of the field [message #432482 is a reply to message #432462] Tue, 24 November 2009 07:45 Go to previous message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm glad you did. Would you mind to share HOW?
Previous Topic: Custom problem : when validate record
Next Topic: Summation
Goto Forum:
  


Current Time: Fri Sep 20 06:59:11 CDT 2024