Looking for Iguana v.5 or v.6? Learn More or see the Help Center.
Using the GUID Generator with SQL Server 2000 |
When you are using SQL Server 2000 with database tables that include a GUID in a column of type uniqueidentifier, it expects GUIDs to be in the following format:
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx |
Here, each x is a hexadecimal digit (0 through 9, or a through f).
The GUID returned by guid.generate_guid() contains hexadecimal digits but no dashes. To convert this GUID to the format that SQL Server 2000 expects, use the following code:
from ifware import guid PatientGuid = guid.generate_guid() value = PatientGuid[:8] + '-' + PatientGuid[8:12] + '-' + PatientGuid[12:16] + '-' \ + PatientGuid[16:20] + '-' + PatientGuid[20:] |