OraFAQ Forum: Forms » insert

Home » Developer & Programmer » Forms » insert_allowed (Oracle IDS10g windows xp)

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

insert_allowed [message #431559]

Wed, 18 November 2009 03:03

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

I have developed PERSONAL PROFILE APPLICATION using Oracle IDS10g.In this application i have created two users like admin and enduser.If i login as admin i can edit the column values(I mean to edit the text boxes).beacuse of defaultly insert_allowed property set to as yes.It works fine.

If i login as enduser I dont edit the column values(I mean donot edit the text boxes).So I write the coding like this

begin
if :employee.userid='admin' then
go_block('profile);
elsif :employee.userid='enduser' then
set_item_property(set_item_property('profile.id',insert_allowed,property_false);
select id,name,designation into :profile.id,:profile.name,:profile.designation from profile where id=5049;
end if;
end;

I run the form and i login as enduser display the record of 5049 but i can edit the values.my question is i dont edit the column values(I mean dont edit text boxes)when i login as end user.How to overcome this problem

Thanks and regards

Varosh

[Updated on: Wed, 18 November 2009 03:10]

Report message to a moderator

Re: insert_allowed [message #431567 is a reply to message #431559]

Wed, 18 November 2009 03:49

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

Senior Member
Account Moderator

In other words, your code doesn't do its job. Right?

If so, is 'admin' really 'admin' or is it perhaps 'ADMIN' or 'Admin' or ...? What happens if you involve, for example, UPPER into

if UPPER(:employee.userid) ='ADMIN' then ...

If that's not the issue, include message/pause pairs into the trigger code so that you could follow its execution. (Or simply run the form in debug mode, as you use Forms 10g. Don't forget to set the breakpoint!)

Report message to a moderator

Re: insert_allowed [message #431573 is a reply to message #431567]

Wed, 18 November 2009 04:19

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

i login as admin

same as i wrote
set_item_property('profile.id',enabled,property_false);
set_item_property('profile.name',enabled,property_false);
set_item_property('profile.designation',enabled,property_false);
it works fine

but insert_allowed not working

thanks and regards
varosh

[Updated on: Wed, 18 November 2009 04:33]

Report message to a moderator

Re: insert_allowed [message #431598 is a reply to message #431573]

Wed, 18 November 2009 07:30

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

Senior Member
Account Moderator

Under normal circumstances, INSERT_ALLOWED works fine. What did you do to prevent it work?

Report message to a moderator

Re: insert_allowed [message #432465 is a reply to message #431573]

Tue, 24 November 2009 06:09

coolbunny111
Messages: 12
Registered: June 2009

Junior Member

You can try this.

set_block_property('block2',insert_Allowed,property_false);

I have tried and its working fine in Oracle 9i forms 6i environment.

Razz

Report message to a moderator

Re: insert_allowed [message #433368 is a reply to message #431573]

Tue, 01 December 2009 23:43

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you solved your problem?

David

Report message to a moderator

Re: insert_allowed [message #433429 is a reply to message #432465]

Wed, 02 December 2009 05:20

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

yet the problem could not solve.
How to overcome this issue

thanks and regards

varosh

Report message to a moderator

Re: insert_allowed [message #433436 is a reply to message #431559]

Wed, 02 December 2009 05:32

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

Senior Member

Is this a queried record you're trying to prevent changes to?

Report message to a moderator

Re: insert_allowed [message #433563 is a reply to message #433436]

Thu, 03 December 2009 00:32

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Yes,I queried the records but the same time nobody cannot edit the records

Thanks and regards

varosh

Report message to a moderator

Re: insert_allowed [message #433584 is a reply to message #431559]

Thu, 03 December 2009 02:31

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

Senior Member

Then the property you need to set is update_allowed not insert_allowed.

Report message to a moderator

Re: insert_allowed [message #433600 is a reply to message #433584]

Thu, 03 December 2009 04:21

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Thanks cookiemonster.Now it works fine

Thankas and regards

Varosh

Report message to a moderator

Previous Topic:	Navigation change after set_item_property enable
Next Topic:	Basic forms doubt

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:29:40 CDT 2024