SqlDbx Forum

Tom

Member

Tinyint Column Width Error

SqlDbx 3.62 (Personal Edition)
Results in Text specified
Output of tinyint data results in extra column width in output

Column:  MONTH tinyint

Query:  select "Mo" = str(MONTH,2) from table where ...

Result:
Mo 
----

The "Mo" column is of width 4, not 2 (as specified) in the query

This happens only with tinyint data type, not smallint or int type.

Is there a fix to this erroneous output behavior?

sqldbxhelp

Administrator

Re: Tinyint Column Width Error

This will be fixed in a next release.