Home » Developer & Programmer » Forms » How to display Serial number adjacent to employees table help plsss (Oracle 9i forms)
How to display Serial number adjacent to employees table help plsss [message #307975] Thu, 20 March 2008 11:25 Go to next message
sqlstar_student
Messages: 42
Registered: November 2007
Member
In a form in tabular format Emp details are displayed

Adjacent to the table i want to put a Sno display item showing
1 for 1st employee
2 for 2nd employee ......

without using a trigger
if its not possible without the trigger then how with a trigger

[Updated on: Thu, 20 March 2008 12:14]

Report message to a moderator

Re: How to display Serial number adjacent to employees table help plsss [message #307990 is a reply to message #307975] Thu, 20 March 2008 13:02 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
One way would be to write a POST-QUERY block-level trigger as
:this_block.sno := :system.trigger_record;

Report message to a moderator

Re: How to display Serial number adjacent to employees table help plsss [message #308028 is a reply to message #307990] Thu, 20 March 2008 16:20 Go to previous messageGo to next message
sqlstar_student
Messages: 42
Registered: November 2007
Member
Let me just get this

Your saying to create a display item called sno and write a post query trigger at block level ex block1

:block1.sno:=:system.trigger_record;

what is this trigger_record here means

how will this populate the sno adjacent to employees in a tabular format

Report message to a moderator

Re: How to display Serial number adjacent to employees table help plsss [message #308068 is a reply to message #308028] Fri, 21 March 2008 00:35 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
what is this trigger_record here means

It is ":SYSTEM.TRIGGER_RECORD" we are talking about. It is one of system variables available in Forms. What does it do? Open Forms Online Help System, search for it and you'll know.

Report message to a moderator

Re: How to display Serial number adjacent to employees table help plsss [message #308120 is a reply to message #308068] Fri, 21 March 2008 05:26 Go to previous messageGo to next message
sqlstar_student
Messages: 42
Registered: November 2007
Member
will this work if i wrote a query in the datablock wizard as

select rownum as sno,last_name,....
from employees

will it create a item with sno adjacent to emp details

Report message to a moderator

Re: How to display Serial number adjacent to employees table help plsss [message #308121 is a reply to message #308120] Fri, 21 March 2008 05:31 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How much would it cost if you try?

Report message to a moderator

Previous Topic: Internal Server Error
Next Topic: Wants to create a txt file through forms and then want to read its data through Forms
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 10 22:11:15 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.