Dear All,

While browsing Some Documents i found that there are few limits , but i didn't understood there meaning pl'z elaborate it for me

Application server (Bshell)

maximum string buffer size is 4k

maximum function stack depth is 75

Tables

maximum record length is 3072 bytes

maximum number of fields is 1024

maximum field length is 3072 bytes

Indexes

maximum index legth is 120 bytes

maximum number of fields is 32 (no combined fields)

pl'z guide

Regards and Thanks

Darpan

Hi there,

some of these limits are old, or only applicable to tbase, but might be still enforced by the development environment.


Some of the following are just good guesses from my side, so anybody feel free to correct.

The stack size is limited to 75, that means in a recursive function only a call depth of 75 can be reached.

A table can have amaximum of 1024 fields, a single field can only be max 3072 bytes long, the same goes for all fields combined.


an index can max. consist of 120 fields. God knows, what the index length is about.

Who can explain the rest?

Regards

Markus

an index can max. consist of 120 fields. God knows, what the index length is about.
Markus, the maximum number of fields is 32 (no combined fields) for an index.

Refer to the link Index Parts Info (http://www.baanboard.com/baanboard/showthread.php?t=9899&highlight=Index+restrictions) to calculate the Index size.