OraFAQ Forum: Forms » Message restriction

Home » Developer & Programmer » Forms » Message restriction

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

Message restriction [message #124932]

Wed, 22 June 2005 06:57

Lee Sutton
Messages: 20
Registered: June 2005
Location: Sheffield

Junior Member

Hello,
I want to view the output of a default_where clause but it is more than 200 chars long. Is there anyway of overcoming this restriction?
Please note I have tried to insert the clause into a temporary table but the insert does not fire as record processing halts part way through the transaction and as yet I do not know a way to force this through.

Many thanks for your help.

Regards

Lee Sutton

Report message to a moderator

Re: Message restriction [message #124954 is a reply to message #124932]

Wed, 22 June 2005 08:41

Lee Sutton
Messages: 20
Registered: June 2005
Location: Sheffield

Junior Member

It's ok. I used 'substr' function to split the message output into 6. Don't know why I didn't think of this before.
Thanks anyway.

Report message to a moderator

Re: Message restriction [message #125044 is a reply to message #124954]

Wed, 22 June 2005 20:41

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

Senior Member
Account Moderator

I create a text item (character 2000) on the control block but show only 10 hytes or so on the screen (in the title area). Then have edit function key 'enabled' / 'available' for it. Navigating to it can be a problem but surmountable. I check to see if the 'canvas' attribute is not NULL. If yes then 'next block' works and I can navigate to the control block and as it is the only displayable field I end up in that field.

David

Report message to a moderator

Re: Message restriction [message #125094 is a reply to message #125044]

Thu, 23 June 2005 04:49

Lee Sutton
Messages: 20
Registered: June 2005
Location: Sheffield

Junior Member

Thanks djmartin - I will try this next time I encounter the problem.

Report message to a moderator

Previous Topic:	NLS settings
Next Topic:	Oracle Forms 9i - Message built-in issue & post-text-item

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:39:09 CDT 2024