Home » Developer & Programmer » Forms » insert_allowed (Oracle IDS10g windows xp)
insert_allowed [message #431559] Wed, 18 November 2009 03:03 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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!)
Re: insert_allowed [message #431573 is a reply to message #431567] Wed, 18 November 2009 04:19 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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?
Re: insert_allowed [message #432465 is a reply to message #431573] Tue, 24 November 2009 06:09 Go to previous messageGo to next message
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 Razz
Re: insert_allowed [message #433368 is a reply to message #431573] Tue, 01 December 2009 23:43 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: insert_allowed [message #433429 is a reply to message #432465] Wed, 02 December 2009 05:20 Go to previous messageGo to next message
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
Re: insert_allowed [message #433436 is a reply to message #431559] Wed, 02 December 2009 05:32 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Is this a queried record you're trying to prevent changes to?
Re: insert_allowed [message #433563 is a reply to message #433436] Thu, 03 December 2009 00:32 Go to previous messageGo to next message
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
Re: insert_allowed [message #433584 is a reply to message #431559] Thu, 03 December 2009 02:31 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
Then the property you need to set is update_allowed not insert_allowed.
Re: insert_allowed [message #433600 is a reply to message #433584] Thu, 03 December 2009 04:21 Go to previous message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
Thanks cookiemonster.Now it works fine

Thankas and regards

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


Current Time: Fri Dec 02 14:32:43 CST 2016

Total time taken to generate the page: 0.14322 seconds