SQLite detects the metadata changes (via the database version cookie) and reloads the schema from the db file, removing (at least) all internal structures it deems outdated or no longer required.
-----Ursprüngliche Nachricht----- Von: Raheel Gupta [mailto:[email protected]] Gesendet: Freitag, 06. Dezember 2013 11:47 An: General Discussion of SQLite Database Betreff: [sqlite] Functions affecting table structure ? Hi, I am trying to add some additional data with the table structure stored in SQLite. Everything seems to be working fine but when I do an alter query it seems to drop the table. I have made changes in the following functions to handle the addition of the data: sqlite3AlterFinishAddColumn() , sqlite3EndTable(), I have made changes in the following functions to remove the changes during runtime only (sqlite feels its a normal table) sqlite3InitCallback(), execExecSql() I am trying to understand the ALTER queries and which function handles them. Any hint would be immensely appreciated. I have wasted a day or two trying to figure out why is the database dropping the structure when I add a column to an existing table (modified by my code) _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -------------------------------------------------------------------------- Gunter Hick Software Engineer Scientific Games International GmbH Klitschgasse 2 – 4, A - 1130 Vienna, Austria FN 157284 a, HG Wien Tel: +43 1 80100 0 E-Mail: [email protected] This e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice as to its status and accordingly please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any person as to do so could be a breach of confidence. Thank you for your cooperation. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
