[sqlite] file db from memory db

I try copying a table from a :memory: data base to a file data base, but could not make it work. Anybody has any suggestions? Thanks I tried something like: open a data base :memory: create table MYTABLE (...) ... attach 'filename.db' as FileDB create table FileDB.MYTABLE as select * from

[sqlite] sqlite with FORTRAN

Hi I am trying to figure out a wrapper to access sqlite from FORTRAN (g77 and gcc) I try using "cfrotran.h" but it seems I have problems passing arguments. Not sure I get the sqlite3 handle correctly Has anybody tried that before? Thanks Cornel