Extracted from this Thread:
Sub UUIDv4 As String
Dim sb As StringBuilder
For Each stp As Int In Array(8, 4, 4, 4, 12)
If sb.Length > 0 Then sb.Append("-")
I was calling an API which requires UUID version 4 to set as one of the headers. I decided to use this website ( https://www.uuidgenerator.net/ ) API to generate the UUID which works fine.
Later, I started looking for ways to generate the UUID v4 internally in the app so I came across this...
I have a PostgreSQL SQL statement like:
private SqlStr as String
EmployeeId = "ef8ba4b3-7898-4240-aa8f-a0586ed04fb7"
SqlStr = "select * from employee where employee_id=?"
Params = Array As Object(EmployeeId)
rs = SQL.ExecQuery2(SqlStr, Params)
This will throw an exception...