Home » Developer & Programmer » Forms » help with form builder format mask
help with form builder format mask [message #201262] Fri, 03 November 2006 05:46 Go to next message
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
Re: help with form builder format mask [message #201263 is a reply to message #201262] Fri, 03 November 2006 05:50 Go to previous messageGo to next message
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
Re: help with form builder format mask [message #201368 is a reply to message #201263] Fri, 03 November 2006 14:21 Go to previous messageGo to next message
lune
Messages: 27
Registered: August 2006
Location: UAE
Junior Member

Thanks a lot samit_gandhi

For answering my question

lune
Re: help with form builder format mask [message #201391 is a reply to message #201368] Fri, 03 November 2006 20:58 Go to previous messageGo to next message
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
Re: help with form builder format mask [message #201552 is a reply to message #201391] Sun, 05 November 2006 18:48 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
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:
  


Current Time: Sat Dec 10 22:06:56 CST 2016

Total time taken to generate the page: 0.05164 seconds