Home » Developer & Programmer » Forms » Form Calendar Issue
Form Calendar Issue [message #375720] Sat, 13 December 2008 10:48 Go to next message
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 178 times)
Re: Form Calendar Issue [message #375732 is a reply to message #375720] Sat, 13 December 2008 13:00 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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.
Re: Form Calendar Issue [message #375758 is a reply to message #375732] Sun, 14 December 2008 03:57 Go to previous messageGo to next message
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.
Re: Form Calendar Issue [message #375774 is a reply to message #375720] Sun, 14 December 2008 08:23 Go to previous messageGo to next message
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
Re: Form Calendar Issue [message #375997 is a reply to message #375720] Mon, 15 December 2008 10:40 Go to previous messageGo to next message
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
Re: Form Calendar Issue [message #383950 is a reply to message #375997] Sun, 01 February 2009 00:16 Go to previous messageGo to next message
thomasscaria
Messages: 21
Registered: July 2007
Location: Kuwait
Junior Member
Hello members,
A sample calendar form is attached.

Regards,
Thomas
  • Attachment: calendar.fmb
    (Size: 144.00KB, Downloaded 237 times)
Re: Form Calendar Issue [message #383951 is a reply to message #375997] Sun, 01 February 2009 00:17 Go to previous message
thomasscaria
Messages: 21
Registered: July 2007
Location: Kuwait
Junior Member
Hello Members,
Another sample calendar form.

Regards,
Thomas
  • Attachment: calendar1.fmb
    (Size: 144.00KB, Downloaded 226 times)
Previous Topic: Deleting record in the called form
Next Topic: Urgent help needed !
Goto Forum:
  


Current Time: Sun Dec 04 08:47:55 CST 2016

Total time taken to generate the page: 0.11441 seconds