Increase Length of field

vyanku

Hi,
I create new field in sales header table having datatype=text ,length=50
But when I am trying to save the table it shows me error

The active field in the record may not take up more than 4000 bytes.The active fields in the sales header table take up 4008 bytes.U must reduce either the number or the length of active field.

What can I do increase length of field??

ssingla

The table in Navision have limited size 4000kb. Each field consumes some kb's depending on its nature and size.
You either need to get rid of some fields you have added to the table or use any other table for storing the info. Then you can use the sub form to display the complete info in one form (Run Time).

vyanku

Where can I see the size of the table??
How can I identified that how much size it already consumed?

Luc_VanDyck

Menu File -> Database -> Info -> Tables

vyanku

Menu File -> Database -> Info -> Tables

there is no option of
table in
file => database => information=>..............

HalMdy

On the information form, use the Button Tables

Luc_VanDyck

vyanku wrote:

Menu File -> Database -> Info -> Tables

there is no option of
table in
file => database => information=>..............

Yes there is

gulamdastagir

ssingla wrote:

The table in Navision have limited size 4000kb.

This is true only for tables in the range 50000-50099

Savatage

gulamdastagir wrote:

ssingla wrote:

The table in Navision have limited size 4000kb.

This is true only for tables in the range 50000-50099

What about 50100

gulamdastagir

50000-99999 :oops:

vyanku

But i am getting this problem in Sales header 36 table.

Waldo

afaik, it's not only for custom tables (50000-99999) but for all tables ... so I guess you'll have to follow ssingla's advice.

gulamdastagir

All i did was put a Field Filter(>4000) on "Size(KB)" the Database Information(tables) form and i found no less than 16 tables and among the Standard navision tables the size of "Value Entry " was 90,656 KB.

[-o< provide me a document about when you create new fields in Standard tables with (Partner License and all types of licenses) what number ranges should be applied to the New Field IDS

frede

Hi,

you cannot see the size of the record-definition anywhere - as I understand.

Below is extract from Application Designers Guide page 579:

Maximum record size 4KB (C/SIDE Database Server), 8KB (SQL Server)


A.2 Specifications for C/SIDE Application Objects
This section lists specifications for the five types of application objects in a C/SIDE
database.
Specifications for Tables
(A) all application objects are identified by an ID number. there are restrictions, however, on the
numbers you can use when you create your own application objects. Please contact your NTR for
more information.
Range for table object ID numbers 1 -999,999,999 (A)
Maximum number of characters in a table name 30
Maximum table size Infinite
Maximum number of records in a table Infinite
Maximum record size 4KB (C/SIDE Database Server), 8KB (SQL Server)
Maximum number of fields in a record 500
Range for field numbers 1 - 999,999,999
Maximum number of keys for a table 40
Maximum number of distinct fields per key 20 for a primary key. The number of fields in the
primary key + the number of fields in a
secondary key which do not occur in the primary
key must always be less than or equal to 20.
Maximum number of SumIndexFields per key 20
Maximum number of characters in a text or code
field
250
Maximum size of a BLOB field 2 GB
Maximum number of characters in a field name 30

vyanku

Thats g8 information.

gulamdastagir

Fred

Thanks for the "Designers Guide"