Sub generateGUID() As String
Dim r As ResultSet=sql1.ExecQuery("select lower(hex(randomblob(16))) as x")
r.Position=0
Dim guid As String=r.GetString("x").SubString2(0,8) & "-" & r.GetString("x").SubString2(8,12) & "-" & r.GetString("x").SubString2(12,16) & "-" & r.GetString("x").SubString2(16,20) & "-" & r.GetString("x").SubString2(20,32)
Return guid.ToUpperCase
End Sub