This was interesting behaviour.... I was running the vbscript on m9 in the 22.214.171.124. the script runs for many hours (depends on the machine). It was taking too long to run so I shut m9 down.
But it appeared the script continued to run (all the cores were still working) and it showed the process still working in windows task manager in the processes tab.
I also couldn't reopen the project until I ended the process in the task manager.
I had this result on two different computers.
On a different note, it was cool to be able to run multiple instances of this script in multiple instances of m9 and for all the cores to be used by each instant. This did speed things up a lot.
Oh - also how do you get the sql to go over two or more lines. There is one other example for m9 on forum but I couldn't replicate it successfully.
I tried for the end of the line
and for the start of the line
And combinations of the above.
code - vbscript m9
Set app = Manifold.Application
Set db = app.GetDatabaseRoot()
j = 1
jmax = 400
text = "delete from efg_sdm_temp1;"
text = "delete from [aatest74 Drawing];"
text = "insert into [aatest74 drawing] (filename, val, geom, sp_id) select * from [sbrass_fe.aatest71 drawing] where sp_id = "&j&";"
i = 1
imax = 57
text = "delete from [temp2 drawing];"
text = "insert into [temp2 drawing] select * from [l10 4] where grid1 = "&i&";"
text = "insert into efg_sdm_temp1 (filename, efg_name, efg_num, tot_ha) select filename, efg_name, efg_num, rounddecs(sum(area_ha),1) as tot_ha from (SELECT [s_Geom], [o_mfd_id],o_efg_name as efg_name,s_filename as filename,o_efg_num as efg_num,geomarea(s_geom,0) / 10000 as area_ha FROM CALL GeomOverlayTopologyIntersectPar([aatest74 Drawing] (filename,geom),[temp2 drawing] ([mfd_id], efg_name, efg_num, [Geom (I)]),0,ThreadConfig(SystemCpuCount()))) group by filename,efg_name, efg_num;"
i = i + 1
loop until i > imax
j = j + 1
loop until j > jmax