Home » Developer & Programmer » Forms » Need help... Sir.. How to disable mouse navigability in the datablock (Oracel 5)
Need help... Sir.. How to disable mouse navigability in the datablock [message #338313] Mon, 04 August 2008 09:43 Go to next message
rffamadico
Messages: 6
Registered: May 2008
Location: Manila
Junior Member
Sir
this is my design in my prototype...
the system would be a additional setup for categories

the CATEGORY represent by CAT_CD would be for every 1 category have many PERIL represent by PERIL_CD for each PERIL have 2 CONTAINER(i.e) containerized and non containerized


EXAMPLE that would be the relationship

C1 ---1--contain
--non contain
2--contain
--non contain
3--contain
--non contain
4--contain
--non contain



my design would be like this

CAT_CD -TEXT ITEM CAT_DESC -- LISTITEM
CAT_DESC -- TEXT ITEM


PERIL CD CONT CD RATE
--------|----|--------|-=--|------
--------|----|--------|----|------
--------|----|--------|----|------
--------|----|--------|----|------
--------|----|--------|----|------

ADD MODIFY

the line in the middle suppose to be my LOV will be selected from the table..

my question
1. in adding in CAT new PERIL how will i reduce or exclude
the containered used. . i.e in peril 1 if contain is already used it will not appear in choices in LOV
-- and if peril is already have the two container how will not be retrieved in my LOV... that is the used of modify

2. in adding new records, i create_record... my problem is it was in one block.... how will i focus only in one rows.. whch prohibit me to navigate in other record// because it is unable//

I used set_item_instance but the problem is it no use because the whole block is enabled... I made it raise_trigger failure in When New record instance but the mouse navigability is in there///

REPLY PLS
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #338399 is a reply to message #338313] Mon, 04 August 2008 18:09 Go to previous messageGo to next message
rffamadico
Messages: 6
Registered: May 2008
Location: Manila
Junior Member
Guys....

Please reply ASAP I need your advise..

Thanks Razz
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #339595 is a reply to message #338399] Thu, 07 August 2008 21:30 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Change the contents of the LOV via the where clause in the record_group.

Use 'set_item_instance_property' to stop navigation and insert/update for a particular item occurrence.

David
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #339765 is a reply to message #338399] Fri, 08 August 2008 07:12 Go to previous messageGo to next message
rffamadico
Messages: 6
Registered: May 2008
Location: Manila
Junior Member
thanks sir,


i already used to set item instance property, and i already disable the key up and down as long as the key nextrecord and previous record. my problem was the whole data block was able to navigate by mouse where my block is set as insert and update allowed is yes.. the system does not accept if only the set_item_intance property(textitem, vcurrecord,....insert allowed) it must the whole block also be set to yes.. so if i click the record i am able to insert.... i want to be focus on the record i want add as long i didnt cancel it or save it....
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #339767 is a reply to message #339595] Fri, 08 August 2008 07:16 Go to previous messageGo to next message
rffamadico
Messages: 6
Registered: May 2008
Location: Manila
Junior Member
sir david

can you give me a sample of changing LOV via where clause,

is it like this

set_block_property(<blockname>, default_where, 'line_cd = '||v_line_cd); ??

is it jzt like that??? is all i need to change block as LOV?
or the record group????

Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #341207 is a reply to message #339767] Sun, 17 August 2008 21:00 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What do you currently have in the record_group for your LOV.

David
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #341617 is a reply to message #341207] Tue, 19 August 2008 10:06 Go to previous messageGo to next message
rffamadico
Messages: 6
Registered: May 2008
Location: Manila
Junior Member
sir,

thanks

my query in record group would be

select peril_cd, peril_name
from peril
where peril_cd = 11

then sample,

it will return peril_cd(01,02,03,04,05),

for every one of the peril it would at least one container type.. would be.. containerized or non containerized..

AS 01 --containerized, non-containerized
02 --containerized, non-containerized
and so on

if ever the peril_cd already used the conttype, i want it, to not appear in the lov for conttype or if both of them are been used it will not appear in the projection of the peril lov...
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #341662 is a reply to message #341617] Tue, 19 August 2008 17:36 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Then include these extra conditions in the 'where' clause of the 'record group'. Use the items in your block to modify the criteria.

By the way, please review your post. You say "where peril_cd = 11" but you also say "it will return peril_cd(01,02,03,04,05),". Well, it won't. If you say "peril_cd = 11" that's all you will receive back.

David
Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #341803 is a reply to message #341662] Wed, 20 August 2008 06:30 Go to previous messageGo to next message
rffamadico
Messages: 6
Registered: May 2008
Location: Manila
Junior Member
sorry sir david..

it must be line_cd = 11

Re: Need help... Sir.. How to disable mouse navigability in the datablock [message #341991 is a reply to message #341803] Thu, 21 August 2008 00:49 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sodding hell!!! Why do you guys even worry about typing the code into your responses, just cut and paste the stuff.

David
Previous Topic: LOV
Next Topic: LOV-Column Mapping Props@Run Time
Goto Forum:
  


Current Time: Mon Dec 05 07:09:10 CST 2016

Total time taken to generate the page: 0.19693 seconds