Public feed #887810

Anonymous

public text v1 · immutable
Raw Edit
·published 2008-02-01 17:00 UTC
rendered paste body
            ins = "INSERT INTO Result(CellTest_id, CellTest_Test_Id, CellTest_Cell_id, Parameter_id, DateAdded, data) "
            ins = ins & "(SELECT '" & dr.GetString(2) & "', '" & dr.GetString(3) & "', '" & dr.GetString(0) & "', '1', ScanTime, Cell" & dr.GetInt32(1) & "I FROM unsec_index.Results_tbl WHERE TestStand =  '" & standname & "' AND TestNumber = '" & testname & "') union "
            ins = ins & "(SELECT '" & dr.GetString(2) & "', '" & dr.GetString(3) & "', '" & dr.GetString(0) & "', '2', ScanTime, Cell" & dr.GetInt32(1) & "V FROM unsec_index.Results_tbl WHERE TestStand =  '" & standname & "' AND TestNumber = '" & testname & "') union "
            ins = ins & "(SELECT '" & dr.GetString(2) & "', '" & dr.GetString(3) & "', '" & dr.GetString(0) & "', '3', ScanTime, Cell" & dr.GetInt32(1) & "P FROM unsec_index.Results_tbl WHERE TestStand =  '" & standname & "' AND TestNumber = '" & testname & "') union "
            ins = ins & "(SELECT '" & dr.GetString(2) & "', '" & dr.GetString(3) & "', '" & dr.GetString(0) & "', '4', ScanTime, Cell" & dr.GetInt32(1) & "T FROM unsec_index.Results_tbl WHERE TestStand =  '" & standname & "' AND TestNumber = '" & testname & "')"