On Wed, Oct 17, 2012 at 3:22 PM, MB Software Solutions, LLC <[email protected]> wrote: > On 10/17/2012 4:18 PM, Frank Cazabon wrote: >> >> @@Identity is only for identity fields. I always generate my own GUID >> locally and insert that along with the rest of the data. My guess is >> that you are going to have to query based on the data that you just put >> into the record (do you have a candidate key?) to get the id > > > > I thought having the DB generate the PK was a good/preferred way but I guess > not. Tried inserting my own made-up value (for example) and got this: > > insert into MyTable (ID,VendorName) values ('MS','Microsoft'); > > "Conversion failed when converting from a character string to > uniqueidentifier." -------------
Is this in VFP or C#? In C# : Guid ID = Guid.NewGuid(); -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajidmy+v6qm7-brbx9yx2cfad79heb0r39pgkmpbqkdahrf...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
