Problem with timestamping

[prem2]

On mySQL I have set up a table with the following fields and properties:

CREATE TABLE stoerungsliste (
ST_ID int(5) NOT NULL auto_increment,
ORDNUNGS_NR text NOT NULL,
START_ZEIT timestamp(14) NOT NULL,
T_MELD_ZEIT1 datetime NOT NULL,
T_RUECK_ZEIT1 datetime NOT NULL,
T_RUECK_ZEIT2 datetime NOT NULL,
ENDE_ZEIT datetime NOT NULL,
T_ENDE_ZEIT datetime NOT NULL,
PRIMARY KEY (ST_ID)
) TYPE=MyISAM;

On the Internal Table Manager of dadabik, I set the START_ZEIT field with the Field Type as insert_update. I reinstalled the table and entered data into the insert form. When I show all the entries, I get 00000000000000 under the START_ZEIT field.

Can anyone help with this? Thanks.

 

[Eugenio]

prem2 wrote:
>
> On mySQL I have set up a table with the following fields and
> properties:
>
> CREATE TABLE stoerungsliste (
> ST_ID int(5) NOT NULL auto_increment,
> ORDNUNGS_NR text NOT NULL,
> START_ZEIT timestamp(14) NOT NULL,
> T_MELD_ZEIT1 datetime NOT NULL,
> T_RUECK_ZEIT1 datetime NOT NULL,
> T_RUECK_ZEIT2 datetime NOT NULL,
> ENDE_ZEIT datetime NOT NULL,
> T_ENDE_ZEIT datetime NOT NULL,
> PRIMARY KEY (ST_ID)
> ) TYPE=MyISAM;
>
> On the Internal Table Manager of dadabik, I set the
> START_ZEIT field with the Field Type as insert_update. I
> reinstalled the table and entered data into the insert form.
> When I show all the entries, I get 00000000000000 under the
> START_ZEIT field.

The START_ZEIT field should be a datetime field, not a timestamp.

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)