OraFAQ Forum: Forms » serial number column forms level

Home » Developer & Programmer » Forms » serial number column forms level

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

serial number column forms level [message #601907]

Wed, 27 November 2013 01:36

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Dear Friends,

Kindly guide me, how to create a serial number column in oracle form level.

Thanks

Haider Ali

Attachment: untitled.GIF
(Size: 35.60KB, Downloaded 856 times)

[Updated on: Wed, 27 November 2013 01:36]

Report message to a moderator

Re: serial number column forms level [message #601909 is a reply to message #601907]

Wed, 27 November 2013 01:47

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try with :SYSTEM.TRIGGER_RECORD in WHEN-CREATE-RECORD (for new records) (and, possibly, POST-QUERY (for queried ones) if "serial number" isn't stored into a table).

Report message to a moderator

Re: serial number column forms level [message #601995 is a reply to message #601909]

Thu, 28 November 2013 05:42

stalin4d
Messages: 226
Registered: May 2010
Location: Chennai, Tamil Nadu, Indi...

Senior Member

Littlefoot wrote on Wed, 27 November 2013 13:17

Try with :SYSTEM.TRIGGER_RECORD in WHEN-CREATE-RECORD (for new records) (and, possibly, POST-QUERY (for queried ones) if "serial number" isn't stored into a table).

in the block level i need to use? how ?

Report message to a moderator

Re: serial number column forms level [message #601999 is a reply to message #601995]

Thu, 28 November 2013 07:47

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

:serial_no := :system.trigger_record;

Report message to a moderator

Re: serial number column forms level [message #602072 is a reply to message #601999]

Fri, 29 November 2013 04:06

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Dear Sir,

Please give a example for me and others friends .

Thanks

Report message to a moderator

Re: serial number column forms level [message #602077 is a reply to message #602072]

Fri, 29 November 2013 04:12

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

That was an example. Put that code in the trigger LF already suggested.

Report message to a moderator

Re: serial number column forms level [message #602078 is a reply to message #602077]

Fri, 29 November 2013 04:18

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Unfortunately i could not understand .
Please make it in FMB file.

I should be very thank full to you Sir,

Report message to a moderator

Re: serial number column forms level [message #602081 is a reply to message #602078]

Fri, 29 November 2013 04:22

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Littlefoot suggested a trigger to use - WHEN-CREATE-RECORD - and then wrote the exact code you need to put in it.
Are you really trying to tell us you can't understand that?

Report message to a moderator

Re: serial number column forms level [message #602087 is a reply to message #602081]

Fri, 29 November 2013 05:02

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Actually Sir,

I am confused due to oracle's forms.
Look I have an example of Table.
S.No emp_id Emp_name.
1 1001 Jhone
2 1003 Ali.
3 1017 Jamy
I want the figures number continuate (1, 2, 3...) on table (Forms) kindly guide how I prepare form ?

Report message to a moderator

Re: serial number column forms level [message #602089 is a reply to message #602087]

Fri, 29 November 2013 05:18

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Is this number supposed to be stored in the DB or just displayed on the form?

Report message to a moderator

Re: serial number column forms level [message #602090 is a reply to message #602089]

Fri, 29 November 2013 05:25

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Just show in forms .
If save in DB then good.

Report message to a moderator

Re: serial number column forms level [message #602091 is a reply to message #602090]

Fri, 29 November 2013 05:30

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

1) Add an item to the datablock with datatype number called serial_no.
2) Put it on the canvas
3) Create a block level WHEN-CREATE-RECORD trigger and a block level POST-QUERY trigger.
4) Put LF's code above in both triggers.
5) Stop convincing yourself you can't do this ridiculously simple thing.

Report message to a moderator

Re: serial number column forms level [message #602094 is a reply to message #602091]

Fri, 29 November 2013 05:42

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

OOOO Really Thank your very ... much Sir.

Its very easy .

you Know i have no words to say your thanks.
Regards

Haider Ali

[EDITED by LF: removed huge font size]

[Updated on: Sat, 30 November 2013 03:43] by Moderator

Report message to a moderator

Re: serial number column forms level [message #602142 is a reply to message #602094]

Sat, 30 November 2013 00:38

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Now Sir,

I have another question that is suppose if I close serial_no 5 then next page should start serial_no 6,7,8......

Please guide me .

Thanks

Haider Ali

[EDITED by LF: removed large font size]

[Updated on: Sat, 30 November 2013 03:43] by Moderator

Report message to a moderator

Re: serial number column forms level [message #602149 is a reply to message #602142]

Sat, 30 November 2013 03:44

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Remember the last value on the "previous page" and add it to :system.trigger_record on the next.

Report message to a moderator

Re: serial number column forms level [message #602315 is a reply to message #602149]

Tue, 03 December 2013 01:43

haider_1pk
Messages: 135
Registered: March 2009
Location: PAKISTAN

Senior Member

Kindly guide how i can add last record in :system.trigger_record ?

Report message to a moderator

Re: serial number column forms level [message #602340 is a reply to message #602315]

Tue, 03 December 2013 04:31

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I didn't say "add in" but "add to".

You could use a parameter (as in my example), a global variable, a form item ... pick the most appropriate one.

:serial_no := :parameter.previous_page_value + :system.trigger_record

Report message to a moderator

Previous Topic:	FRM-40735: WHEN-BUTTON-PRESSED trigger raised unhandled exception
Next Topic:	Help me on code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 22:19:00 CDT 2024