>>hi- >>as i am creating a program that works with sqlite, i notice that each time i make a change to the table >>structure i lose the data (i think it is because create table is invoked) >>so basically if i understand it right i have to export data to a file before restructure and then after the table >>structure is changed import the data back into the newly modified table. is that right? >>i am not ready to try to create an export/import feature on my program. i think that is too advanced for >>me right now. >>does anyone know of or use a free program that can export sqlite tables to a file and import sqlite tables from a file? >>i tried sqlitemanager but i didnt get it to work. i will have to go check and see if the documents are in >>english yet. maybe it works and i just dont know how to use it. i will look at it tomorrow again. >>thanks for any input, >>marvin right after i wrote this email i found the dump command . if you still want to answer my questions that is fine and i appreciate it . at least i found a starting point. thanks, marvin
