OraFAQ Forum: Forms » Max length at runtime

Home » Developer & Programmer » Forms » Max length at runtime

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

Max length at runtime [message #218590]

Thu, 08 February 2007 19:36

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Is it possible to change the maximum lenght of an item at runtime? I can't find any on set_item_property.

Report message to a moderator

Re: Max length at runtime [message #218619 is a reply to message #218590]

Fri, 09 February 2007 00:19

Frank
Messages: 7901
Registered: March 2000

Senior Member

Don't hassle too much with forms at runtime. It is very disturbing for users and very error-prone.
Maybe you'd better rethink your design.

Report message to a moderator

Re: Max length at runtime [message #218878 is a reply to message #218590]

Sun, 11 February 2007 18:00

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Are you talking about the maximum length of the database field, the length of the item in the form, or the displayed length of the item?

David

Report message to a moderator

Re: Max length at runtime [message #218882 is a reply to message #218590]

Sun, 11 February 2007 18:37

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

maximum length of the database field or in my case, it's it's a non-database item. I found this link, but I don't know if I can apply this on oracle 5. http://forums.oracle.com/forums/message.jspa?messageID=1275531#1275531

[Updated on: Sun, 11 February 2007 20:00]

Report message to a moderator

Re: Max length at runtime [message #218889 is a reply to message #218882]

Sun, 11 February 2007 22:50

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Oracle Forms 5 or Oracle Release 5?

David

[Updated on: Sun, 11 February 2007 22:53]

Report message to a moderator

Re: Max length at runtime [message #218890 is a reply to message #218590]

Sun, 11 February 2007 22:59

wency
Messages: 450
Registered: April 2006
Location: Philippines

Senior Member

Oracle 5 R2.1, forms 5 ver5.0.6.8.0

Report message to a moderator

Re: Max length at runtime [message #219290 is a reply to message #218890]

Tue, 13 February 2007 20:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

I know that 'forms_ddl' exists in Forms 5 but I don't know whether it works in Oracle release 5. If you want it for a non-database field in Forms just make the item length equal to the maximum length supported. I think it is 64k minus 1 or 2, but it could be 32k - 1 or 2.

David

Report message to a moderator

Previous Topic:	SQL command concat with block name problems..
Next Topic:	toolbar in a form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 22:22:42 CST 2025