DATA Field Problem
Posted: 09.06.2007, 09:53
I have to convert a db table from (small example):
CREATE TABLE [dataold] (
[id] INTEGER NULL PRIMARY KEY,
[data_txt] TEXT NULL
)
to the table:
CREATE TABLE systems (id INTEGER NOT NULL PRIMARY KEY,date DATE)
I an insert for the migration:
INSERT INTO 'systems' SELECT id, data_txt FROM 'dataold';
The data are stored in the data_txt in the following format DD.MM.YYYY
Everything looked fine but when I looked to the inserted data-fields the new generated data fileds are empty.
I open the database file within an other SQlite Client and all the data items are there ...
What could be wrong?
Thanks for your help!
CREATE TABLE [dataold] (
[id] INTEGER NULL PRIMARY KEY,
[data_txt] TEXT NULL
)
to the table:
CREATE TABLE systems (id INTEGER NOT NULL PRIMARY KEY,date DATE)
I an insert for the migration:
INSERT INTO 'systems' SELECT id, data_txt FROM 'dataold';
The data are stored in the data_txt in the following format DD.MM.YYYY
Everything looked fine but when I looked to the inserted data-fields the new generated data fileds are empty.
I open the database file within an other SQlite Client and all the data items are there ...
What could be wrong?
Thanks for your help!