[kexi] [Bug 335154] Lack of Report Design toolbar

[Jarosław Staniek]

https://bugs.kde.org/show_bug.cgi?id=335154

--- Comment #29 from Jarosław Staniek <staniek at kde.org> ---
Cool. Future proof scripts can be used as follows:
1. Table T is (a int, b text);
2. You export data by generating script S such as:
INSERT INTO T (a, b) VALUES (1, 'foo');
INSERT INTO T (a, b) VALUES (1, 'bar');
..

Note the "(a, b)" explicitly specified.

3. Then if add columns so T is (a int, b text, c text) the script S will still
work (as stated before, as long as the new column isn't NOT NULL. You can use
the script as is, without appending extra empty values.

In contrast, CSV is less precise. In the future we'll want to have it possible
to specify what column of CSV goes to what field on data importing. This
specification could be also useful if it's saved somewhere.

-- 
You are receiving this mail because:
You are the assignee for the bug.