| Need help... Sir.. How to disable mouse navigability in the datablock [message #338313] |
Mon, 04 August 2008 09:43  |
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 #339765 is a reply to message #338399] |
Fri, 08 August 2008 07:12  |
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 #341617 is a reply to message #341207] |
Tue, 19 August 2008 10:06 |
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...
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
