Andy Choens said the following, On 2007-06-04 22:41: > Any ideas would be greatly appreciated. I do not want to manually recreate > the > offending table because of the complexity of the table, I am afraid more > errors could work their way in. If there is any way to extract and re-use the > raw SQL used to make the original table, I could use that to create a new > table, and import my data into this table, but I don't know how to get this > information in Kexi. If requested, I can send the file to you off list.
Hello, Could you please send me (privately) a database with such a table? Before I find the possible bug, there is a way to export: ksqlite db.kexi .dump > dump.sql Then locate appropriate CREATE TABLE line and INSERT INTO lines. After editing the SQL dump, you can import the result: ksqlite newdb.kexi < editeddump.sql If you have access to the source code of Kexi 1.1.2, there are kexi/tools/add_column and kexi/tools/delete_column tools that can help to preserve yoru data when adding/deleting a column. -- regards / pozdrawiam, Jaroslaw Staniek Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work on Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, http://www.kde.org _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
