OraFAQ Forum: Forms » Sequence Number

Home » Developer & Programmer » Forms » Sequence Number (Windows XP Oracle Forms 6i,)

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

Sequence Number [message #313672]

Mon, 14 April 2008 02:32

*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 543 times)

Report message to a moderator

Re: Sequence Number [message #313674 is a reply to message #313672]

Mon, 14 April 2008 02:45

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Sequence Number [message #313679 is a reply to message #313672]

Mon, 14 April 2008 02:57

*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

Report message to a moderator

Re: Sequence Number [message #313682 is a reply to message #313679]

Mon, 14 April 2008 03:12

Littlefoot
Messages: 21823
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;

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 11 12:28:23 CDT 2025