Home » Developer & Programmer » Forms » maximum number of items in a data block (oracle forms builder 6.0)
maximum number of items in a data block [message #348287] Tue, 16 September 2008 06:13 Go to next message
barcelonist
Messages: 2
Registered: September 2008
Junior Member
hi everyone

i need to know what is the maximum number of database items in a database data block (in oracle forms builder 6.0). The datasource of this datablock is a table that contains more than 100 columns, and we need to create about 100 items in the same datablock. I know that the maximum columns in an oracle table is 999 columns, but any of you know if what we want to do is possible?

thanks in advance

Report message to a moderator

Re: maximum number of items in a data block [message #348293 is a reply to message #348287] Tue, 16 September 2008 06:28 Go to previous messageGo to next message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I have never tried to do that, but - I believe that if you are capable of viewing 100 items on the screen, Forms will certainly be capable of handling such a design.

Report message to a moderator

Re: maximum number of items in a data block [message #348755 is a reply to message #348287] Wed, 17 September 2008 21:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Absolutely no idea.

Create a test form, use the block wizard, select ALL columns, compile, generate, and run the form, and see what happens.

I would be interested to know the result.

David

Report message to a moderator

Re: maximum number of items in a data block [message #348851 is a reply to message #348287] Thu, 18 September 2008 02:23 Go to previous messageGo to next message
barcelonist
Messages: 2
Registered: September 2008
Junior Member
hi

thanks to everyone, i've tested it and everything goes fine. i use almost 100 items but no problem, even it's pretty fast

Report message to a moderator

Re: maximum number of items in a data block [message #349089 is a reply to message #348851] Thu, 18 September 2008 19:20 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Can it handle ALL the columns from your 999 column table?

David

Report message to a moderator

Re: maximum number of items in a data block [message #349130 is a reply to message #349089] Fri, 19 September 2008 00:22 Go to previous message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No need to do that (so far) - there is
barcelonist
a table that contains more than 100 columns, and we need to create about 100 items

Report message to a moderator

Previous Topic: Oracle Forms App Re-architecting
Next Topic: Automatic Trigger fire
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 03 23:11:34 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.