exec

Hi Experts, This is SQlite Update Code Dim count,limit,offset As Int count = db.ExecQuerySingleResult($"select count(*) from a"$) limit = 100 offset = 0 Do While offset < count db.ExecNonQuery( _ $"UPDATE a SET amt= (update sum values here)...

I have tried many different ways to accomplish this however to no avail. here is my code. Dim runit As Shell Private switches As List switches.Initialize switches.Add("/user:johns") switches.Add("password") runit.Initialize("net use J:",$"\\example\windows\share"$,switches) runit.RunSynchronous(-1)