Home » Developer & Programmer » Forms » Forms 6i to 10g
Forms 6i to 10g [message #585278] Thu, 23 May 2013 07:42 Go to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Hi,
While migrating Forms 6i to 10g i have come across one unique behavior
1. In Forms 6i- Suppose we have a text item of datatype char and length 5.
Now copy a text of 10 characters 1234567890 and paste it in the text box and it will automatically trim and take
1st 5 characters(12345) and show in text box.
2. In Forms 10g- Suppose we have a text item of datatype char and length 5.
Now copy a text of 10 characters 1234567890 and paste it in the text box and it nothing happens. Character length
is more than 5 then it does nothing.

I need to implement the 6i behavior in 10g. Any suggestions (apart from validation trigger). Any property available?
Re: Forms 6i to 10g [message #585514 is a reply to message #585278] Mon, 27 May 2013 03:21 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
From my point of view, Forms 10g fixed a bug in Forms 6i version which allowed you to enter value longer than item's maximum length allows. Yes, it was smart enough and trimmed the value, but that's also misleading behaviour because you weren't warned that it happened. After you have saved data and thought that everything's in there, you'd - some time after - perform query and wonder what happened.

It is obvious that you can actually SEE what happened in a 5-characters long item, but that could have been an item that allows, say, 200 characters, but you displayed only first 20 of the whole item. You wouldn't even know that the rest was trimmed (because you couldn't see it).

Finally: no, I wouldn't know how to implement it (apart from using a trigger).
Re: Forms 6i to 10g [message #585525 is a reply to message #585514] Mon, 27 May 2013 04:24 Go to previous messageGo to next message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Thanks for your suggestion Littlefoot. By any chance you have the bud id, or Oracle provided document related to this fixed bug?
Just for reference and explanation to client.
Re: Forms 6i to 10g [message #585526 is a reply to message #585525] Mon, 27 May 2013 04:33 Go to previous messageGo to next message
Littlefoot
Messages: 19320
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
It seems that I wasn't clear enough - that "bug" maybe (most probably!) doesn't exist, I saw it as a bug. Maybe creators of Forms 6i intentionally designed it that way, I don't know. I just said that Forms 10g work as I'd expect them to - do not allow insertion of a value which is larger than specified by item's length.
Re: Forms 6i to 10g [message #585527 is a reply to message #585526] Mon, 27 May 2013 04:34 Go to previous message
sankalputtara
Messages: 53
Registered: January 2011
Location: Bangalore
Member
Thanks again for your suggestions Smile
Previous Topic: pleas help me :)
Next Topic: Do you want to save changes yes/no button code
Goto Forum:
  


Current Time: Mon Jul 28 14:07:04 CDT 2014

Total time taken to generate the page: 0.19402 seconds