OraFAQ Forum: Forms » help with form builder format mask

Home » Developer & Programmer » Forms » help with form builder format mask

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

help with form builder format mask [message #201262]

Fri, 03 November 2006 05:46

lune
Messages: 27
Registered: August 2006
Location: UAE

Junior Member

Hi all,

I'm a new member here and I liked your forum

I have a question if anyone can help I will really appreciete your help

I build up my form using form builder and my question is that I want the the pimary key of the table to start with one capital letter then 4 numbers like P001 what will be the format mask for the feild ??

I tried this P9999 but it didn't worked

if you know how I can do it please help me because I need it

Report message to a moderator

Re: help with form builder format mask [message #201263 is a reply to message #201262]

Fri, 03 November 2006 05:50

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

Hi

For this make one field which is numeric and non-database field and its format mask is 0009. than increment this field and contactinate the capital with this field and store it in ur primary key field.

hope ur problem is solved

samit

Report message to a moderator

Re: help with form builder format mask [message #201368 is a reply to message #201263]

Fri, 03 November 2006 14:21

lune
Messages: 27
Registered: August 2006
Location: UAE

Junior Member

Thanks a lot samit_gandhi

For answering my question

lune

Report message to a moderator

Re: help with form builder format mask [message #201391 is a reply to message #201368]

Fri, 03 November 2006 20:58

ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India

Senior Member

Hi,

You can write a pre-insert trigger at data block level.

Bye
Ashu

Report message to a moderator

Re: help with form builder format mask [message #201552 is a reply to message #201391]

Sun, 05 November 2006 18:48

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You can also use the 'When-Create-Record' trigger.

If it is critical that there be no 'holes' in the displayed sequence please consider having a displayed key ('P001') and a hidden 'true' key based on an Oracle sequence. If is easier to handle in a multi-user environment.

David

Report message to a moderator

Previous Topic:	Problem in Locking
Next Topic:	Urgent Help Error 0 at line, column 0 ORA-00600: internal error code, arguments:[17069],[72229968],[

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 13:37:54 CDT 2024