I had problems in getting GUID on Mac, Windows and Linux…
I found a solution:
Function Method_Generate_GUID() As String Dim db As New SQLiteDatabase Dim Sql_instruction As String= "select hex( randomblob(4)) " _ + "|| '-' || hex( randomblob(2)) " _ + "|| '-' || '4' || substr( hex( randomblob(2)), 2) " _ + "|| '-' || substr('AB89', 1 + (abs(random()) % 4) , 1) " _ + "|| substr(hex(randomblob(2)), 2) " _ + "|| '-' || hex(randomblob(6)) AS GUID" If db.Connect Then Dim GUID As String = db.SQLSelect(Sql_instruction).Field("GUID") Return GUID db.Close End If End Function
Perhaps it might be helpful to someone else :)
Rob