PRB - MySQL TINYINT auto increment primary key columns are shown as editable in insert mode.
Tuesday, 25 November 2008
When you are using smartDBforms.NET with MySQL and editing a database table where the primary key columns is auto increment and of type TINYINT, then in insert mode the
column is shown as editable instead of readonly.
SYMPTOMS
When you are using smartDBforms.NET with MySQL and editing a database table where the primary key columns is auto increment and of type TINYINT, then in insert mode the
column is shown as editable instead of readonly.
CAUSE
MySQL reports the columns of type TINYINT as not being auto increment columns, even though the column has been configured to be auto increment column.
RESOLUTION
The problem appears only for TINIINT columns. You can fix the problem if you change the
type of the column to INTEGER type.
Another way is to set the ForceReadOnlyInEdit property of the corresponding
SmartDBControl to True.
APPLIES TO
- MySQL 5.0 and above with MySQL ODBC 5.1 Driver
|