Clive Richmond
16-Feb-2016, 05:17 AM
The help and the DataFlex specification indicates the maximum size for a text column may be 16,384 bytes with the usable size 2 bytes less than the declaration. Sounds good. However I am unable to set the value above 16,208.
Text: Embedded database Text columns permit a maximum size of 16KB. Enter a number between 0 and 16384. If the number entered is not divisible by 16, it will be increased to the next multiple of 16. Other database types may permit different entries.
9773
This initial problem came to light when I tried “convert to embedded” an SQL table containing a text column and the structure copy failed.
I have only tested this in DataFlex 18.2 RC2 so can’t comment if this is new or an existing issue. Also I did notice that binary columns also exhibit a similar problem.
Text: Embedded database Text columns permit a maximum size of 16KB. Enter a number between 0 and 16384. If the number entered is not divisible by 16, it will be increased to the next multiple of 16. Other database types may permit different entries.
9773
This initial problem came to light when I tried “convert to embedded” an SQL table containing a text column and the structure copy failed.
I have only tested this in DataFlex 18.2 RC2 so can’t comment if this is new or an existing issue. Also I did notice that binary columns also exhibit a similar problem.