Saving scrollview as new SQL file

[tcgoh]

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

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]

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.