Size does matter.

Bgestel

Hi,

Question 1:
I can i quickly know the size of my record definition.
Is this the blob size or one of the size's in database->information->tables

Question 2:
What is the maxium size a record definition can be?

I ask this because i Fear running in to the techical maximum size for the purchase line. And would like to anticipate on this.

Question 3:
Who has a smart idea , say i want to add another field to the table when the maximum size is reached. The only constraint is that they need to be presented in the same tablebox on the form.

Thx in advance

fufikk

I guess I would create second table with the same PK, add required fields, and on the form (with the initial-out-of-fields-table) make use of OnAfterGetRecord trigger or something - fetch the record from the secod table and show stuff on the form

ara3n

I agree with fufikk.
Also your title looks like a lot of spam that I get on my hotmail account.

Bgestel

thx for the answers to question 3 , now what about 1 and 2 :?:

kriki

ara3n wrote:

Also your title looks like a lot of spam that I get on my hotmail account.

True, when I saw the title I was already ready to moderate the post until I read it and saw it wasn't spam.

Bgestel

I used that title to lure in , the knowledge full moderators. :whistle:

Arhontis

Bgestel wrote:

Question 1:
I can i quickly know the size of my record definition.
Is this the blob size or one of the size's in database->information->tables

The record size in on database->info....
The blob size on object designer is the size of the object.

I guess the max size depends on the SQL server, don't know about the native version of nav...

Arhontis

EDIT:reposted the same... I must be drunk...

DenSter

You can disable fields that are not used, and that takes away from the max record size.

DenSter

Oh and ehm.... you're right, it does :whistle:

David_Singleton

Bgestel wrote:

Hi,

Question 2:
What is the maxium size a record definition can be?

The maximum size of the record definition is 4000 bytes. This is a limitation since ver 2.01, and for compatibility between native and SQL, the same limit applies to SQL.

This is the total of the maximum size of fields if fully populated. Calculating it is a bit complex, but the formula is in the manuals.