Kbase P124193: Why is dbtool menu item 1, with verbose level of 1 or higher, reporting Max Width of 0 for some fiel
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/31/2007 |
|
Status: Unverified
GOAL:
Why is dbtool reporting Max Width of 0 for some fields?
FIX:
Fields which are reported with a Max-Width of 0, are generally special field types, such as dates which have logical values and are always the same size, or fields which contain an empty string. When data in the field meets either of these conditions the Max-Width will be reported as 0.
Fields like EmailAddress and Fax in the Progress Sports2000 database are columns have values which are either Null or contain an empty string (0 bytes).
Looking at the SQL-scan reports against the sports 2000 database there are fields reported with a max-width of 0.
ie:
dbtool run against the sports2000 database with the SQL Width & Date Scan w/Report Option and a verbose level 1 or higher,
will report the fields Fax and EmailAddress in table customer of having a Max-Width of 0, because all of these fields are either Null or 0 bytes in length.
Max Width
18: 40 0 Fax
19: 100 0 EmailAddress
After updating one record to contain an EmailAddress and a Fax number running dbtool again the results will have changed:
18: 40 12 Fax
19: 100 18 EmailAddress
The invoice table which has an invoicedate column and contains a date, shows Max-Width as 0 because the size is not changeable.
4: Date 0 InvoiceDate