after csv import to sqlite table

After I import data from a csv file into a sqlite database file, I can no longer save the data from within a Lazarus made program. Although I can alter and save the data within a database manager. When I click Commit which applys the updates, The cursor moves to the first record in the DB grid and erases any changes?? This has got me stumped. If I remake the table and not import any data from a csv text file, the program works fine. Not sure what info I could include. That database does not have an auto increment field. Here are the commands I used for import:

.separator ":" .import data.csv moneyDB.db

Any help would be greatly appreciated!