Home » Developer & Programmer » Forms » Sequence Number (Windows XP Oracle Forms 6i,)
Sequence Number [message #313672] Mon, 14 April 2008 02:32 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi guyz

Im attaching my form snapshot i wanna to do some changes in this module

in SL_no i wanna insert sequence number or any symbol how can i do this but this will fire when new form instance

there is 8 menu item in that form as shown in the snapshot is there any way that someone have only 4 menu access so it should display only four menu item the rest shud be not displayed. and how can do the auto increment of text_item field in detail block?

Regards

  • Attachment: Sequnce.JPG
    (Size: 49.39KB, Downloaded 145 times)
Re: Sequence Number [message #313674 is a reply to message #313672] Mon, 14 April 2008 02:45 Go to previous messageGo to next message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Where do you get these menu names from? Some table, I suppose. So - add another column which will be this "sl_no"; you'll use it for ORDER BY purposes as well.

As of displaying some items or not: every user should have its own "menu name" information. This table would look like
user_1   menu_1
user_1   menu_4
user_2   menu_1
user_2   menu_7
user_2   menu_8
So, for each user select only those items that are entered into this table.
Re: Sequence Number [message #313679 is a reply to message #313672] Mon, 14 April 2008 02:57 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Well im taking these menus from one table.like below

Name Null? Type
------------------------------- -------- ----
USERNAME NOT NULL VARCHAR2(15)
PASS VARCHAR2(15)
STATUS CHAR(1)

Name Null? Type
------------------------------- -------- ----
USERNAME VARCHAR2(15)
MENUS VARCHAR2(30)

THESE are the table just i wanna to add the sequence # or any symbol on that form.

menus will display on runtime each user have access on modules like (Invoicing, reports) some user dont have access on these menus so they can view only reccords etc etc.

(i.e. if user have 4 modules so sequence will display 1,2,3,4 or any symbol if i want...)

Can you explain how can i do this sequence.

Regards
Re: Sequence Number [message #313682 is a reply to message #313679] Mon, 14 April 2008 03:12 Go to previous message
Littlefoot
Messages: 20897
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a POST-QUERY block-level trigger with such a code:
:this_block.seq_item := :system.trigger_record;
Previous Topic: How to get Hard Disk Size,Cluster, processor Name,speed using Forms 6i
Next Topic: How to find out if item is synchornized with another one
Goto Forum:
  


Current Time: Wed Dec 07 06:35:53 CST 2016

Total time taken to generate the page: 0.07137 seconds