OraFAQ Forum: Forms » Form Calendar Issue

Home » Developer & Programmer » Forms » Form Calendar Issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Form Calendar Issue [message #375720]

Sat, 13 December 2008 10:48

georgebush
Messages: 7
Registered: December 2008

Junior Member

Hi,

I created the calendar referring to one of the forums here.

Every first time I click the arrow buttons (< or > or << or >>) in the calendar

I get the following 2 errors :-

frm-40831 Truncation occured:value too long for field prev_item

followed by

frm-40105 unable to resolve reference to it date_control_block.month_minus

It throws these 2 errors but performs the functionality of the button.

Please let me know if someone could assist me in solving this error

Attachment: erro.jpg
(Size: 25.60KB, Downloaded 622 times)

Report message to a moderator

Re: Form Calendar Issue [message #375732 is a reply to message #375720]

Sat, 13 December 2008 13:00

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Item "prev_item" is too small and can not get the whole value it is supposed to. For example, it is declared as VARCHAR2(2) and you are trying to insert 'ABC' into it so - 'C' is being truncated off. Enlarge it!

"Unable to resolve reference" error means that you are trying to navigate to a non-existent item. Search for it in PL/SQL form units and fix the error.

Report message to a moderator

Re: Form Calendar Issue [message #375758 is a reply to message #375732]

Sun, 14 December 2008 03:57

mahatab
Messages: 98
Registered: January 2008
Location: Dhaka

Member

Why don't you attach the .fmb file for all of us. it will be helpful for all of us and as well as solving your problem. Depends whether you are really appreciate our help. To help you, you may better help others. So send us the .fmb file and let us try.

Report message to a moderator

Re: Form Calendar Issue [message #375774 is a reply to message #375720]

Sun, 14 December 2008 08:23

georgebush
Messages: 7
Registered: December 2008

Junior Member

Thank you Little foot and Mahatab.

I resolved this issue by taking the directions of Little foot.

Every time I was clicking the buttons in the calendar(< > << >>)

It was calling the new_item_instance trigger in the block level which was in turn calling another function which was causing the issue.

Anyway thank you guys.

Happy holidays !

PS. Mahatab going forward I will attach the .fmb files

Report message to a moderator

Re: Form Calendar Issue [message #375997 is a reply to message #375720]

Mon, 15 December 2008 10:40

mahatab
Messages: 98
Registered: January 2008
Location: Dhaka

Member

Thanks Buddy,
This forum has got some wonderful people i have ever meet. All of them are so kindly and they have also helped me a lot to solve many serious problem. I will be very happy if you could attach the .fmb file for all of us.

Regards,
Mahatab

Report message to a moderator