I have a SQL server database with several tables that have GUIDs for primary keys that are automatically generated by SQL newID default value. (I don't want to get into a debate on the pro's and cons of that, that is just how it has to be for now). I am trying to create a basic front end to that in Access (2010 - but the issue seems to ...
what's a nice, fast way to sort a list of GUIDs (as TGuid). i thought i'd just use SysUtils.CompareMem(P1, P2: Pointer; Length: Integer): Boolean; until i realized it returns boolean. i'd wish for something comparable to CompareText( ) or CompareValue( ) that return integer so it can be used in a sort comparison. i suppose not many pe...
I'm not a developer. I need to hack an XML file to duplicate hundreds of resources that are each assigned a GUID. Is there a way to parse the entire file, replacing each GUID found in a tag with a dynamically generated one? Basically - every UniqueID tag (but not the ContentUniqueID tags) needs a new GUID. <root xmlns:xsi='http://ww...
I'm trying to port an NSIS installer to WiX. Every time the installer runs it sets a registry key to a new GUID value, so that when my app runs it can see if it's first run after an install. On first run the app sets another registry key to the GUID value from the installer. As long as the two keys match then I know the installer hasn...
How are GUIDs generated in C#? ...
When my program written in C# or VB.NET or other .NET family language runs on Windows and calls System.Guid.NewGuid() is generation always performed by forwarding the call to UuidCreate() provided by Windows or are there other ways of generating? ...
GUIDs are typically used for uniquely identifying all kinds of entities - requests from external systems, files, whatever. Work like magic - you call a "GiveMeGuid()" (UuidCreate() on Windows) function - and a fresh new GUID is here at your service. Given my code really calls that "GiveMeGuid()" function each time I need a new GUID is t...
The reason why I ask this is because I want to relate a given winmm audio device like the ones you open using waveInOpen with a directSound device. ...
Hello. While deciding upon the keys for a table, is it good to have an INT primary key (autoincrement) for the table and a GUID (in addition to the INT) for the scope of the database? Given that there will be more table DML statements it will be faster to operate on INT whereas if any pan-database DMLs statements are to be executed, GUID...
I have a .NET application which allows users to access various databases by providing a connection string and a provider. One of the databases which users want to access is a MySQL database (not mine so I can't change it) where the primary keys are all stored as GUIDs. My application can access records in various tables in that databas...
Using a .msi package, I want to create a few registry keys if they don't exist, leave them alone if they do exist, and not delete them if the program is removed. I have done this (using Orca) by adding entries to the following msi tables: Components, FeatureComponents, Registry, & LockPermissions. My question is what should I do about ...
Are there PHP libraries to generate sequential GUIDs for usage in a MySQL database? ...
Does anyone know how to deal with this error? cannot convert from 'System.Guid?' to 'System.Guid' ...
Is it possible to use the guid.comb strategy for identity generation with Mysql Db using Nhibernate? When I use it as mapping.Id(x => x.Id) .Column("row_guid") .CustomType(typeof(string)) .GeneratedBy.GuidComb() .Length(36); I end up with a ----> System.InvalidOperationException : Identi...
Subsonic is returning 00000000-0000-0000-0000-000000000000 when I insert a record and try to get it's key after insert. product.Save(); GUID = product.ProdID; The record is inserted correctly with correct GUIDs. Any idea on how to resolve this? I am using version 2.2.0.0 This is my table schema GO SET ANSI_NULLS ON GO SET QUOTED_I...
Does anyone have a nice code snippet for a Guid to Base34 encoder/decoder, I've googled around for it previously and never really found any good sources. ...
I need a way to uniquely identify a computer using .NET that works in both Windows and Linux. The methods used in both operational system do not have to be the same. That is: I can have an approach for Mono running on Linux and another approach for .NET running on Windows. I took a look at another similar question on SO and it seems th...
I have a service bus, and the only way to transform data is via JavaScript. I need to convert a Guid to a byte array so I can then convert it to Ascii85 and shrink it into a 20 character string for the receiving customer endpoint. Any thoughts would be appreciated. ...
Hello All I am planning on using sequential guids as primary keys/uuids as detailed in the post below http://stackoverflow.com/questions/170346/what-are-the-performance-improvement-of-sequential-guid-over-standard-guid/170363#170363 I am wondering if there are any gotchas as far as generating these guids across multiple web servers in...
Okay, here is the scenario... I have created a subfolder in a document library, and when an item is added to the document library, i want to do some processing on the document and then move the item to the subfolder, say MySubFolder. For that purpose, i will be using this statement SPListItem folder = this.workflowProperties.List.Folder...