Sub combine(male AsList, female AsList)
Dim m_result AsList
Dim f_result AsList
Dim m_percent AsList
Dim f_percent AsList
m_result.Initialize
f_result.Initialize
m_percent.Initialize
f_percent.Initialize
m_result = male.Get(0)
m_percent = male.Get(1)
f_result = female.Get(0)
f_percent = female.Get(1)
Main.SQL1.BeginTransaction
Try
Main.SQL1.ExecNonQuery("DELETE FROM data")
For i = 0To m_result.Size-1
For j = 0To f_result.Size-1
Log( m_result.Get(i) & "/" & f_result.Get(j) & "'," & (m_percent.Get(i) * f_percent.Get(j)) & ")")
Log( m_percent.Get(i) * f_percent.Get(j) )
Log( f_percent.Get(j))
Main.SQL1.ExecNonQuery("INSERT INTO data (genetics, percent) VALUES ('" & m_result.Get(i) & "/" & f_result.Get(j) & "'," & (m_percent.Get(i) * f_percent.Get(j)) & ")")
Next
Next
Main.SQL1.TransactionSuccessful
Catch
Log(LastException.Message)
EndTry
Main.SQL1.EndTransaction
Dim Cursor1 AsCursor
Dim test AsList
test.Initialize
Cursor1 = Main.SQL1.ExecQuery("SELECT DISTINCT(genetics), SUM(percent) FROM data GROUP BY genetics, percent")
For i = 0To Cursor1.RowCount -1
Cursor1.Position=i
test.Add(Cursor1.getstring2(0) & " - " & Round2((Cursor1.GetString2(1) * 100), 2) & "%")
Next
Cursor1.Close
Msgbox(test, "Output")
End Sub