Home » Developer & Programmer » Forms » datablock properties
datablock properties [message #118303] Wed, 04 May 2005 04:12 Go to next message
jonmich005
Messages: 53
Registered: April 2005
Member
I have a datablock and the property 'Number of records displayed' is 20.
I have a the property 'Multiline' on my item set on 'YES'.
Now my problem:

Only a few of those 20 records is displayed in multine but not all of them.
What's teh problem????

Report message to a moderator

Re: datablock properties [message #118326 is a reply to message #118303] Wed, 04 May 2005 07:31 Go to previous messageGo to next message
fahedakhter
Messages: 39
Registered: March 2005
Location: Pakistan
Member
Hai.
I think that you check your record if record is less then 20 then how it is display exact 20.Or you chechk your query may be it cannot retrieve 20 record.If both are correct then inform me.

Report message to a moderator

Re: datablock properties [message #118327 is a reply to message #118326] Wed, 04 May 2005 07:35 Go to previous messageGo to next message
jonmich005
Messages: 53
Registered: April 2005
Member
I don't understand.
Even in my layout editor you see that there are only a few records displayed in multiline and not all of them.
Is there a specific property to see that all the records are displayed in multiline?

Greets

Report message to a moderator

Re: datablock properties [message #118330 is a reply to message #118327] Wed, 04 May 2005 07:49 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Have you checked the "Number of items displayed" property of this multi line item? Most probably it's set to a lower number than the "number of records displayed" property of the block. To set it equal to the number of records in the block, set the item property "Number of items displayed" to 0 (zero).

MHE

Report message to a moderator

Re: datablock properties [message #118331 is a reply to message #118330] Wed, 04 May 2005 07:52 Go to previous messageGo to next message
jonmich005
Messages: 53
Registered: April 2005
Member
That is alright, the property is standing on 0(zero)

Report message to a moderator

Re: datablock properties [message #118377 is a reply to message #118331] Wed, 04 May 2005 15:24 Go to previous messageGo to next message
lavallee_g
Messages: 22
Registered: May 2005
Location: Quebec
Junior Member
Number of record buffured must also usualy match the number of records displayed...

Genevieve

Report message to a moderator

Re: datablock properties [message #118398 is a reply to message #118303] Wed, 04 May 2005 20:23 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Can you move the fields around on your canvas to get the multi-line fields to display correctly or 'no matter what' the 2nd, 5th, and 8th lines NEVER display in multi-line format?

David

Report message to a moderator

Re: datablock properties [message #118824 is a reply to message #118398] Mon, 09 May 2005 01:48 Go to previous messageGo to next message
jonmich005
Messages: 53
Registered: April 2005
Member
Only if I set my property 'Bevel'' on plain, it shows everything in multiline.
Else never.

Report message to a moderator

Re: datablock properties [message #118830 is a reply to message #118303] Mon, 09 May 2005 02:39 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What is the point height of your field? What is the font size you are using?

Beveling uses 2 points for the top line and two points for the bottom line. I suspect that if you are using a 12 point font and have set your field to be 'about' 2 lines high, you may be just a bit too small in height. That is, the display field may be only 26 points high and there is not enough space for two lines to be displayed as two lines requires 2 times 12 = 24 plus 2 top and 2 bottom = 28 points all up. There may also be a need for a 1 or 2 point separator between the lines 'in' the box.

Try increasing the high of your box and see what happens.

David

Report message to a moderator

Re: datablock properties [message #118832 is a reply to message #118830] Mon, 09 May 2005 02:45 Go to previous messageGo to next message
jonmich005
Messages: 53
Registered: April 2005
Member
If I set the property on plain, it works.
Should this work also with the bevel 'lowered'?

Report message to a moderator

Re: datablock properties [message #118833 is a reply to message #118303] Mon, 09 May 2005 03:10 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Please answer the two questions in the first line of my previous reply.

David

Report message to a moderator

Re: datablock properties [message #118835 is a reply to message #118833] Mon, 09 May 2005 03:33 Go to previous messageGo to next message
jonmich005
Messages: 53
Registered: April 2005
Member
the height is 100 and the font size is unspecified so that is a standard I think

Report message to a moderator

Re: datablock properties [message #118837 is a reply to message #118303] Mon, 09 May 2005 03:48 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Which version of forms are you running?

Is it all of a particular field which is not doing multiline or is it only some occurrences of the same field?

David

Report message to a moderator

Re: datablock properties [message #118841 is a reply to message #118837] Mon, 09 May 2005 04:08 Go to previous messageGo to next message
jonmich005
Messages: 53
Registered: April 2005
Member
I'm running forms 6.0.
I know it is old but the company hasn't have a newer version.
Some occurences of the same field are in multine and others not.

Report message to a moderator

Re: datablock properties [message #118948 is a reply to message #118303] Mon, 09 May 2005 19:13 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Don't worry about the version. My current site is 4.5 character (for very good reasons). My previous sites have been 10g, 9i, and 6i/6. If you want to run both the DB and application on the same machine then you have to stay with the older versions.

In 6i there is a setting called semi- or half-bevel. Try that instead of full bevelling as it only uses 1 pixel at the top and bottom instead of 2 top and bottom that bevelling uses. This may give you enough space in the multi-line to make it work.

IF YOU HAVE TIME, manually set the font to 12 points, as the field is 100 piints, 100 divide by 12 equals 8 plus 4 (makes 2 points top and bottom). Try making the fields 101 or 102 or 103 or 104 points.

But you say that some occurrences of the same field work and others don't. Is it the 2nd, 5th, and 8th occurrences which don't work? Which ones specifically?

Are you running patchset 4? If so, you should go to patchset 13. DON'T GO HIGHER.

David

Report message to a moderator

Previous Topic: dynamic sql in forms
Next Topic: 2 Problems Form Wont Run Without DataBlock / “FRM-40405”
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 02:31:42 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.