tcgoh Active Member Licensed User Longtime User Aug 4, 2012 #1 Hi All, Is there a way to save a scrollview after a SQL.ExecQuery from a bigger SQL file into a "NEW" smaller SQL file ? I could use B4X: List1=DBUtils.ExecuteMemoryTable(SQL,Qry,Null,0) SaveCSV(File.DirDefaultExternal, "filename.csv", ",",List1) But I have to convert the csv file to SQL again. Thanks and regards
Hi All, Is there a way to save a scrollview after a SQL.ExecQuery from a bigger SQL file into a "NEW" smaller SQL file ? I could use B4X: List1=DBUtils.ExecuteMemoryTable(SQL,Qry,Null,0) SaveCSV(File.DirDefaultExternal, "filename.csv", ",",List1) But I have to convert the csv file to SQL again. Thanks and regards
Erel B4X founder Staff member Licensed User Longtime User Aug 4, 2012 #2 Use another SQL object and insert the new records to the new database. You should go over the items in List1 and insert them. You can use DBUtils.InsertMaps. Upvote 0
Use another SQL object and insert the new records to the new database. You should go over the items in List1 and insert them. You can use DBUtils.InsertMaps.