Kbase P39462: If the SQL WIDTH is 32K for a field Progress database what is the red that field?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
If the SQL WIDTH is 32K (max) for a field, what is then red from that field?
GOAL:
If SQL WIDTH is 32K for a field and it contains 5 bytes, if red is it 32k or 5 bytes?
FIX:
If the SQL WIDTH is 32K (max) for a field in a Progress Database and it contains 5 bytes it is only the actual size that is red.
I.e. 5 bytes are returned if that is the content of the field even if SQL WIDTH is 32K.
Note.
If e.g. using sports2000, you want to read all customers with zip code larger than xxx the query will have a similar size of all returned fields, which is the biggest of them.