[KEXI] [Bug 408012] Editing Max Length property of table field requires data removal

[Jarosław Staniek]

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

Jarosław Staniek <staniek at kde.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Editing number of allowable |Editing Max Length property
                   |characters in any field     |of table field requires
                   |cell leads to deletion of   |data removal
                   |all data in table           |

--- Comment #1 from Jarosław Staniek <staniek at kde.org> ---
Confirmed, thanks. 

Manual workaround for any KEXI version:

1. Close your KEXI database and back up it.
2. Open the sqliteman app or equivalent one. 
Note: You can do the same with sqlite3 console app if you have skills. You can
do the same with MySQL Admin or PostgreSQL Admin for server KEXI databases.
3. For given table T run this query to find out its id: select o_id from
kexi__objects where o_name='T'. Note down the o_id number.
4. For that o_id value (e.g. 217) and for given length (e.g. 1000) and field
name (e.g. 'c') run this query: update kexi__fields set f_length=1000 where
t_id=217 and f_name='c'
5. Repeat steps 3 and 4 for any number of tables and fields you need. You can
use skip the "and f_name='c'" part of the query to set all fields in the table
to give length.
Note: This operation does not truncate or extend length of actual data, you
need to do that separately using other queries. This makes implementation of
the task more complex than it looks: actual data modification may be needed.

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