| Update a date field using calendar [message #203785] |
Thu, 16 November 2006 05:27  |
mane
Messages: 7
Registered: May 2006
|
Junior Member |
|
|
How to create a calendar in oracle forms by using bean item and PJC for a multiple record block?
After creating the calendar, the problem is during runtime, the calendar returns the date to the next record but not to the current record in a multirecord block.
Kindly clarify and give a solution to update the date in the current row.
How i did,
In the implementation class property of the bean item,
oracle.forms.demos.CalendarWidgetWrapper.
In the When_custom_item_event trigger associated with the bean item,
declare
paramtype number;
newdateval varchar2(80);
newdate date := null;
begin
if (:system.custom_item_event = 'DateChange') then
get_parameter_attr(:system.custom_item_event_parameters,'Datevalue',paramtype,newdateval);
newdate := to_date(newdateval,'DD/MM/YYYY');
:block1.start_date := newdate;
end if;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Update a date field using calendar [message #204447 is a reply to message #204357] |
Mon, 20 November 2006 16:41  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Instead of "message(:system.cursor_record);" try "message(get_block_property('block1',current_record));" as the cursor and the current record can be different.
Have you searched this forum for 'calendar' and looked at how other people have used it?
David
[Updated on: Mon, 20 November 2006 16:42] Report message to a moderator |
|
|
|
| Re: Update a date field using calendar [message #204463 is a reply to message #204447] |
Mon, 20 November 2006 21:25 |
mane
Messages: 7
Registered: May 2006
|
Junior Member |
|
|
Sir,
We used the message code you sent still the core of the issue remains. Our problem is when we do mouse click at random in a row in the run form and do mouse click in the calender, it is not updating the current row. This you can also see in the run form we have sent.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
