[sqlite] file db from memory db

[Cornel Gazdaru]

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  MYTABLE
detach FileDB