| To fetch a single record from multiple records based on a condition [message #541040] |
Fri, 27 January 2012 04:25  |
 |
poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI
|
Member |
|
|
Hello,
I have made a travel booking system which comprises of 3 forms
1)Travel Booking form
2)Reservation Form
3)Cancellation Form
Under one booking number i can add multiple users in which they can have there multiple travels.
Users can cancel there individual travels under a prescribe booking number which on doing the Cancel flag turns to 'Y'.
What i want is, If a user is cancelling his/her travel under any booking number then while retriving the records in Travel Booking form, the travels which are cancelled should not be in enable mode.
For one user there can be 4 travels out of which 2 are cancelled,
how can i track only those records whoes cancel flag is set to Y.
Please suggest me some logic to find it out.
Else can i use :system.cursor_record. If yes, How to use it for this system.
Thanks.
|
|
|
|
|
|
|
|
|
|
| Re: To fetch a single record from multiple records based on a condition [message #541044 is a reply to message #541043] |
Fri, 27 January 2012 04:45  |
|
poojamunj
Messages: 64
Registered: May 2011
Location: MUMBAI
|
Member |
|
|
i used the following code on on_populate_details trigger of 2nd block:
if :tra_trv_dtl.TTD_TCT_CAN_FLG = 'Y' then
set_item_property('tra_trv_dtl.TTD_TRV_MODE',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_TRV_CLASS',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_SRC',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_DEST',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_REF_NO',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_PURPOSE',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_CNT_NO',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_BKED_BY',enabled,property_false);
set_item_property('tra_trv_dtl.BUTTON_DT1',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_TRV_DT',enabled,property_false);
set_item_property('tra_trv_dtl.TTD_OTH_REQ_FLG',enabled,property_false);
-- set_item_property('tra_trv_dtl.TTD_OTHER',enabled,property_false);
else
set_item_property('tra_trv_dtl.TTD_TRV_MODE',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_TRV_CLASS',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_SRC',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_DEST',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_REF_NO',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_PURPOSE',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_CNT_NO',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_BKED_BY',enabled,property_true);
set_item_property('tra_trv_dtl.BUTTON_DT1',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_TRV_DT',enabled,property_true);
set_item_property('tra_trv_dtl.TTD_OTH_REQ_FLG',enabled,property_true);
-- set_item_property('tra_trv_dtl.TTD_OTHER',enabled,property_true);
end if;
this code is working on thistrigger but the only problem is it is not fetching single record for which the travel is cancelled. it is making the entire block as disabled which i dont want.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
