Hi, I am working in 3.3.6 Now I am working with inmemory concept. Actually I am copying all the contents of the database into temporary table. Then I am inserting one record in that temporary table. But I need that record to be returned finally in to the original database file.
Is there any other way to do this. I did the following. "ATTACH DATABASE 'test.db' AS Newdb" "CREATE TABLE INMEMORYTABLE AS SELECT * FROM Newdb.temp" "DETACH DATABASE Newdb" insert into INMEMORYTABLE(d,name) values(7,'name7');" select * from INMEMORYTABLE ;" Can any one help.I want that inserted record in the temporary table to be in the original database[ test.db] Best Regards, A.Sreedhar.
