Home » Developer & Programmer » Forms » prevent an item from being copied (oracle forms 10g win xp)
prevent an item from being copied [message #492423] Mon, 31 January 2011 02:12 Go to next message
anutosh100
Messages: 5
Registered: January 2011
Junior Member
Hi experts,
Could you please tell me how can i prevent an item from being copying. I mean to say user will not able to
copy the value from the item and paste in notepad.

The item will be enabled also i can not desable it.

please help.

anutosh
Re: prevent an item from being copied [message #492427 is a reply to message #492423] Mon, 31 January 2011 02:28 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Even if you disable copy/paste, everyone can simply read that value from the screen and type it into Notepad. Why would you want to do that, anyway?
Re: prevent an item from being copied [message #492428 is a reply to message #492427] Mon, 31 January 2011 02:34 Go to previous messageGo to next message
anutosh100
Messages: 5
Registered: January 2011
Junior Member
Actually i shall make the font so small no one is going to read it. If you have any kind of solution please share with me.

Anutosh
Re: prevent an item from being copied [message #492480 is a reply to message #492428] Mon, 31 January 2011 07:51 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If that's the case, why wouldn't you hide that item? Either set its DISPLAY property to NO, or put it to a NULL canvas.
Re: prevent an item from being copied [message #492520 is a reply to message #492480] Mon, 31 January 2011 21:32 Go to previous messageGo to next message
anutosh100
Messages: 5
Registered: January 2011
Junior Member
actually out of 10 records i want to hide 2 records.That i have achived but user is able to copy the hidden content and if he paste it in any notepad he can view it.

So could you please tell me the way to make it protected other then disableing the item.

regards
anutosh
Re: prevent an item from being copied [message #492541 is a reply to message #492520] Tue, 01 February 2011 01:47 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think that you should explain the whole problem in details so that someone might suggest a solution. Discovering piece by piece leads to confusion. At a moment, SET_ITEM_INSTANCE_PROPERTY is what I can think of (but that doesn't have to be "it").
Re: prevent an item from being copied [message #492546 is a reply to message #492541] Tue, 01 February 2011 02:21 Go to previous messageGo to next message
anutosh100
Messages: 5
Registered: January 2011
Junior Member
Ok then let me explain the whole thing.

There are 3 users of my data base. In abc table each of them have some data. The requirement is one user will only able to view his data only. That's why i had to use set_item_instance_property with such visual attribute which will minimize the font size of data of other user. But the problem i am facing is though the font is very small the user can copy it and paste it to any notepad software where he/she can view the data of other.


That is why i am asking about any technique even PJC if you preffer just share the idea with me.

Regards
Anutosh
Re: prevent an item from being copied [message #492553 is a reply to message #492546] Tue, 01 February 2011 02:55 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a DEFAULT_WHERE clause that will contain a condition that restricts fetch according to a current user. Set it with SET_BLOCK_PROPERTY. Doing so, every user will see only his/her own data (I suppose there's a column that distinguishes users one from another).
Re: prevent an item from being copied [message #492563 is a reply to message #492553] Tue, 01 February 2011 03:12 Go to previous messageGo to next message
anutosh100
Messages: 5
Registered: January 2011
Junior Member
Thanks for your idea,
but there are certain item of the table that should be viewed by every user and some confidentail items are there where view is restricted hopefully now you have understood the problem.

Please help.
Regards
Anutosh
Re: prevent an item from being copied [message #492572 is a reply to message #492563] Tue, 01 February 2011 03:40 Go to previous message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Your data model is wrong. The restricted items should be in a different table to the common ones.
The only safe way to stop users accessing data in forms is to change the where clause to prevent them querying that data.
Previous Topic: d2k connect to non oracle databases (merged)
Next Topic: List Item Issue
Goto Forum:
  


Current Time: Tue Sep 17 16:22:55 CDT 2024