Zoltan_Gyimesi
Legendary Poster
More questions in one bunch - VARLEN size, ProcOpt parameter and Grid Cloumn limitations, etc.
Hi JDElist,
It looks like it, I will have an extreme challenge based on one of our customer. It is not technically extrem - it is extreme, because the requested solution requires numerous (more hundreds) Processing Option parameters and grid columns. This raises several questions for me. Release is XE SP 23.
Let's see in order.
#Q1.
How can I interprete exactly the Size parameter of a VARLEN (Variable Length Character Filed) like PODATA?
Is it a size constrain?
#Q2.
Is there any known limitation on Processing Options?
- number of elemnts, e.g. based on PO Id size
- the total size of fields (PODATA is VARLEN end its Length is 2000 in Data Dictionary)
I found the following in the Development Tools manual
[ QUOTE ]
Data Structure Objects
Data structure header size is 237 bytes.
Data structure item size is 72 bytes.
Maximum number of data structure items to fit in 32K is (32768-237)/72 for 450
elements.
In order to leave space for literal values you should limit your structure size to 350
elements or less. Any data structure approaching a size of 100 elements or more
should be considered carefully.
[/ QUOTE ]
#Q3.
Is there any constrain on the number of Grid Columns?
I know the 250 constain on Form Controls, Table C and BSVW Columns, so I can suppose there is also for Grid Columns. BSVW constrain is not a hard for me, because I can add DD Items to the Grid, which is not BSVW field.
#Q4.
Is there any BSFN or other method, ti figure out, is there any error on a specied Grid Row? (I haven't found)
By the way, I try to influnce our customer to an other direction, suggesting alternative solution.
Thanks in advance & Regards,
Zoltán
Hi JDElist,
It looks like it, I will have an extreme challenge based on one of our customer. It is not technically extrem - it is extreme, because the requested solution requires numerous (more hundreds) Processing Option parameters and grid columns. This raises several questions for me. Release is XE SP 23.
Let's see in order.
#Q1.
How can I interprete exactly the Size parameter of a VARLEN (Variable Length Character Filed) like PODATA?
Is it a size constrain?
#Q2.
Is there any known limitation on Processing Options?
- number of elemnts, e.g. based on PO Id size
- the total size of fields (PODATA is VARLEN end its Length is 2000 in Data Dictionary)
I found the following in the Development Tools manual
[ QUOTE ]
Data Structure Objects
Data structure header size is 237 bytes.
Data structure item size is 72 bytes.
Maximum number of data structure items to fit in 32K is (32768-237)/72 for 450
elements.
In order to leave space for literal values you should limit your structure size to 350
elements or less. Any data structure approaching a size of 100 elements or more
should be considered carefully.
[/ QUOTE ]
#Q3.
Is there any constrain on the number of Grid Columns?
I know the 250 constain on Form Controls, Table C and BSVW Columns, so I can suppose there is also for Grid Columns. BSVW constrain is not a hard for me, because I can add DD Items to the Grid, which is not BSVW field.
#Q4.
Is there any BSFN or other method, ti figure out, is there any error on a specied Grid Row? (I haven't found)
By the way, I try to influnce our customer to an other direction, suggesting alternative solution.
Thanks in advance & Regards,
Zoltán